Using the Sorting tab in the header, you can define the fields to sort by, and the order of items to be displayed. Additionally, you can define the number of items to be displayed. For example, if the sort order is Top 5, the report displays the 5 different highest values. If each of the top 5 values has 10 records, there will be a total of 50 rows displayed in the report.
To apply a custom sort:
1. Click the Sorting tab header. The sort parameters are displayed in the activity area on the page.
2. From the Sort By dropdown list, select the column by which to sort.
Note: When Select One is the Sort By column value, the list is sorted by the contents of the first (leftmost) column, which is the lowest summary level.
3. From the Sort Order dropdown list, select the sort order.
Note: You can continue customizing the report by clicking another tab header, or you can return to the default activity area by clicking the Value Selections tab header.
Modify Reports - Applying Ascending and Descending Sorts
Modify Reports - Adding, Deleting, or Changing Report Summarization Parameters