Sorting on aggregate function

  • Thread starter Thread starter michael c
  • Start date Start date
M

michael c

I have report that is grouped by
Division/Region/Territory/detail; I'm actually not showing
any data in the detail section.

The sales numbers roll up from territory on up and are
pulled from a query that shows all the sales for each
territory. I'm trying to get the report to sort the
territories by one of its calculated fields:
=Sum([QTDvAVGQTD])

So, I put =Sum([QTDvAVGQTD]) in the sorting and grouping
dialog box under Regions and above territories but it
won't let me sort by an aggregate function. Any
suggestions would be great. Thanks!
 
SOrting and grouping is done on the underlying data, If
you put the Sum([QTDvAVGQTD]) in the underlying query you
should be able to sort/group as you wish.
Hope this helps.
Fons
 
Back
Top