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 displays 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 (for example, Profit Sum, Year).

• No Sort Order

  This sort option is displayed for all column data types (that is, 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 (for example, Region, City).

Sort Type

Use this drop down list to select a value that determines whether 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 displays 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.