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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing a count function for a report 1
Sum If multiple conditions 3
Aggregate of Group Aggregate 2
count function - how to use like SUMPRODUCT in Excel 3
Sorting and Grouping issue 2
Dynamically sorting a report 2
Summing Count queries 1
Sorting within grouping 3

Back
Top