How to sort data on a crosstab worksheet

You sort a crosstab when you want to change the default sort order that is automatically applied to crosstab worksheets (for more information, see "About sorting on crosstab worksheets").

To sort data on a crosstab worksheet:

1. Display the worksheet that you want to sort.

2. Choose Tools | Sort to display the "Sort Crosstab dialog".

   
   Description of the illustration sct.gif
   
   

3. Select the item that you want to sort from the Item to Sort list.

   The Sort Details for: <worksheet item> table below shows which data point items are used to sort the selected item.

4. Click Add to add a new row to the Sort Details for table and specify sorting options as required.

   Hint: You can also:

   • remove a sort item by selecting an item in the Sort Details for table and clicking Delete

   • rearrange the precedence of sort items by selecting an item in the Sort Details for table and clicking either Move Up or Move Down

5. Click OK to save the details and close the Sort dialog.

   Discoverer refreshes the worksheet according to the sort options that you select.