Edit Worksheet dialog: Sort tab

Use this tab to change the default sort order of items on the current table worksheet. For example, you might want to order numerical sales data from highest to lowest to look at sales performance.

For more information, see:

"About sorting on table worksheets"

"How to sort data on a table worksheet"

"Examples of sorting"

Sort List

Use this list to manage how the worksheet data is ordered. Sorts are arranged in order of precedence.

Note: Group sorts automatically take precedence over non-group sorts.

Column

This field displays the name of the item on which the data is ordered.

Direction

Use this drop down list to change how the data is ordered.

• Low to High sorts A - Z alphabetically and 1 - 10 etc. numerically (language specific).

• Hi to Low sorts Z - A alphabetically and 10 - 1 etc. numerically (language specific).

Sort Type

Use this option to group data and not display duplicate values. For example, if you sort on year, and there are many rows for 2001, the value 2001 will only be displayed for the first row with that value. Note the following:

• Items sorted on group take precedence over items not sorted on group.

• Changing an item to group sort automatically moves it to a higher position in the sort list over items not sorted on group.

For more information about group sorting, see "What is group sorting?".

Hidden

Use this option to hide or display the sorted item on the worksheet, as follows:

• Select the Hidden check box to hide the sorted item.

• Clear the Hidden check box to display the sorted item on the worksheet.

Add

Use this button to add a new sort to the worksheet. The sort is added to the sort list. Click the button to display a list of items available, then click an item to create a sort on that item.

Delete

Use this button to remove the sort currently selected in the sort list from the worksheet.

Move up

Use this button to change the order of precedence of the selected sort item. Moving a sort up the list increases its precedence.

Move down

Use this button to change the order of precedence of the selected sort item. Moving a sort down the list decreases its precedence.

Options

Use this button to display the Options dialog. Use the Options dialog to specify:

• how Discoverer handles queries (see "Options dialog: Query Governor tab")

• how Discoverer formats worksheets (see "Options dialog: Sheet Format tabs")

Notes

• You can also drag and drop items into a difference position in the sort list to change the order of precedence.