Sorting on aggregate function

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!
 
F

Fons Ponsioen

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
Aggregate of Group Aggregate 2
Sorting and Grouping issue 2
Sorting within grouping 3
Sorting and Grouping 2
Access MSACCESS - Sorting report based on field calculated in the report 0
Coordinating the sort order in a report with the underlying query 2
Aggregate function to sort of report 5

Top