Sorting output items
You can specify that data in each output column is sorted in ascending or descending order, and specify the order in which the columns are sorted. The sort order does not affect the display sequence of the output columns.
To specify how the data in a query is sorted:
- Click the icon in the Output pane of the Query & Analysis Query Definition dialog box.
- For each column to be sorted, click in the Sorting Type field and select a sorting option.
- Click the , , , and icons in the toolbar to specify the order in which to sort the columns.
- Specify whether the query should return all rows, a specified number of rows, or a specified percentage of rows.