Sort by group total

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have a report using a query that contains a "total"
field that is summed. My report is grouped by "customer",
showing the customer name in the group header and
the "total" in the group footer. The report is currently
sorted by ascending customer name. How can I keep my
customer group together, with totals at the end of each
group, but sort by the "total" that is in the group
footer?

Thanks for your help
 
Alex,

One way to do this, is to make a Totals Query, which gives you a total
per customer, such as the totals that you presently have calculated in
the grpoup footer of the report. Then, add this query to the query that
the report is currently based on, joined on the applicable customer
field. Then, this per customer total figure should be available to be
used within the report's Sorting & Grouping as the basis of the first sort.
 
Back
Top