How to sort items and measures in a worksheet

You can change the order in which items and measures are displayed by using the Sort tool.

Note: Sort tools are not available for crosstab worksheets based on relational data. Crosstab worksheets based on relational data are sorted by the worksheet creator in either Discoverer Plus or Discoverer Desktop.

To sort items and measures in a worksheet:

1. Display the worksheet that you want to analyze (for more information, see "How to open a Discoverer worksheet").

2. Select the Sort link to display the sort tools above the worksheet data.

3. The available sort tools depend on the type of data source, as follows:

   • on a table worksheet containing relational data, use the Sort and Order fields to select sort options, or select the More link to display the "Multiple Sort page", which enables you to do more complex sorting

   • on a worksheet containing multidimensional data, use the Sort, Based On, and Order fields to select sort options

   Discoverer sorts the worksheet data according to the sort options you have specified.