sort on running total? 1

[mbDutch]

Hello -

I have a report with 2 groups. Group 1 - Branch and
group 2 - Customer. In group footer 2 I have a running total field that sums invoice totals by Customer. Is there a way to sort on that running total field? I want to have the Customer with the highest invoice amount (for that branch) at the top (rather than alphabetically by customer).

Thanks in advance,

Marco

 

[lbass]

Why are you using a running total? Try placing the amount field in the detail section and inserting a sum on it. Then you can go to report->group sort and do a group sort on the summary, descending.

You can't sort on running totals. If the inserted summary doesn't give you the correct value, then please explain exactly how the running total is set up.

-LB

 

[mbDutch]

Thanks LB!