Edit Worksheet dialog: Sort tab (on a crosstab worksheet)

Use this tab to change the default sort order of items on the current worksheet. For example, you might want to order numerical sales data from highest to lowest to look at sales performance, or change the way that data is sub-grouped.

For more information, see:

"About sorting on crosstab worksheets"

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.

What is the location of the items you want to sort?

Use these radio buttons to choose whether to sort the data on the left axis or the top axis.

• Above the data

  Use this radio button to sort horizontally along the selected row item.

• Along the left side of the data

  Use this radio button to sort vertically on the selected column item.

Data Point

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

Column

This field displays the name of the item on which the data is ordered. This field is blank if the sort item is not a data point.

Direction

Use this pull 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).

Add

Use this button to add a new sort to the worksheet. The sort is added to the sort list above. 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 it precedence.

Move down

Use this button to change the order of precedence of the selected sort item. Moving a sort down the list decreases it 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.