Sorting a Report 1

[davidchipman]

HI hope someone can help...
I am currently running a report to generate the top 250 customers to our business by annual billings. The fields i am using is client ID, Group Name, and Annual Billings. When I create my report using the report wizard I select Group Name as my grouping level as a group may contain many client IDs (i.e. Group A has client id 123, and client 124). After this I select summary options and sum up the totals for the group. Here is my problem...I want to sort by the sum of these total billings but my report is sorting by group name. If i accomplish this, i can see who are our top clients. any help would be greatly appreciated. thanks

 

[67peshawar294]

David,
Create your totals in the query you are using.
In a blank QBE grid type
Total:sum([billing])
Or create a new query and use the "summary" option to get the totals, then use the "Totals" field in the query for your sort.
jim