## Top N/Sort Group Expert

This Expert appears when you choose the Top N/Sort Group Expert command from the Report menu.

Use the Top N/Sort Group Expert to identify "top" groups (the best sales representatives in a sales report, the biggest customers in an order report, the states with the most customers in a customer report, and so on).

Use the Top N/Sort Group Expert to sort all of the records in a report or just the top or bottom groups of records. Depending on which option you choose the Expert appears with different options.

##### Group/Sort

Use this list to choose one of the following sorting options for your Top group:

- Sort All groups
- Sort the Top N group
- Sort the Bottom N group

##### based on

This list displays a list of summary fields in your report. Select the field you want to select Top N or Bottom N values for from this list. When Sort All groups is selected, use the scroll box below the based on list to see the fields chosen for sorting.

##### where N is

Enter the number of Top N or Bottom N values (where N is the number of 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 N or Bottom N selection under a specified group name. Enter the group name you want all fields that do not fit into your Top N or Bottom N selection to appear under.

##### Delete

Click this button to delete the selected summary field. This is only available when Sort All Groups is selected.

##### Ascending/Descending

Select the Ascending option to sort the fields in ascending (A to Z, 1 to 9) order.

Select the Descending option to sort the fields in descending (Z to A, 9 to 1) order.

###### Related topics

Sorting, Grouping, and Totaling

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com