Group Sort Expert Dialog Box
Use the Group Sort Expert to identify top or bottom groups (the states with the most/fewest customers in a customer report, for example). You can also identify top or bottom percentages.
This dialog box appears when you right-click the Report Designer, point to Report, and click Group Sort Expert.
Note
A report must contain a summary value in order to be able to perform a Group Sort. See Summarizing Grouped Data.
| For this group sort | Use this list to choose one of the following sorting options for your group:
Depending on which option you choose, the expert displays different options. |
| based on | This list displays a list of summary fields in your report. Select the field you want to select top or bottom values or percentages for from this list. When All is selected, use the scroll box beneath the "based on" list to see the fields chosen for sorting. |
| Where N is | Enter the number of top or bottom values (where N is the number of values) you want to select into this edit box. |
| Where Percentage is | Enter the percentage of top or bottom values you want to select into this edit box. |
| Include Others, with the name | Select this option if you want to include all fields that do not fit into your top or bottom selection under a specified group name. Enter the group name you want all fields that do not fit into your selection to appear under. |
| Include ties | Select this option to accommodate groups whose summarized values are equal. |