Multiple Sort page

This page enables you to specify how Discoverer Viewer sorts the data displayed in worksheet columns.

First Sort, Second Sort, Third Sort

These rows determine the priority in which sorts are applied to the displayed data.

Column Header

Use the drop down list to select the column that you want to sort by.

Sort Order

Use this drop down list to select a value that determines the order in which Discoverer will display column values.

Discoverer displays different values in this drop down list depending on whether the data type of the selected Column Header is numeric or alphanumeric, as follows:

Ascending or Descending

These two sort option values are displayed when the column data type is numeric (e.g. Profit Sum, Year).
No Sort Order

This sort option is displayed for all column data types (i.e. for both numeric and alphanumeric data).
A-Z or Z-A

These two sort option values are displayed when the column data type is alphanumeric (e.g. Region, City).

Sort Type

Use this drop down list to select a value that determines whether or not Discoverer displays the Column Header data sorted in groups. For example, if you selected Group from this drop down list and Department was already selected from the Column Header drop down list, Discoverer will display data grouped by Department.

Note: Discoverer enables you to apply the Group value only when you select Group from the drop down list in the First Sort row.

Discoverer displays the following values in the drop down list:

Normal

Discoverer displays data sorted by the selected Column Header.
Group

Discoverer displays data in groups based on the value selected in Column Header.

Hide Column

Use this check box for Discoverer to sort the table based on the values selected, but not to display any data for this column.