Groups can be organized in either ascending or descending order by summary value. For example, in an orders report, if you subtotal the order amount by state, you could order the groups:
You order the groups by summary values using the Group Sort Expert.
To order groups by summary value
Note You must have a summary field in your report for the Group Sort Expert to be available. See Summarizing Grouped Data.
The Group Sort Expert dialog box appears with a tab for each of the summarized groups in the report.
The summary drop-down list on the right is for those cases in which you have multiple summaries within a single group section. For example, in an orders report, you might sum and average the orders for each customer and then display both the sum and the average in the same group section. In such a case, you would select the sum or the average from this drop-down list.
When you run the report, the program will order the groups based on the summary value(s) specified.
Hiding Details in Summary Reports | Adding Percentages to a Report | Enhancing Report Presentation