Sort Tables

You can sort a table. For example:

Unsorted Table (default):

After sorting:

The following are some of the ways to sort a table:

To...	Do This...
Sort based on the values in a column or row	Right-click the column or row you want to sort on. Select either Sort > Ascending or Sort > Descending.
Remove sorting of values in a column or row	Right-click the column or row you want to remove the sorting from. Select Sort > Advanced. In the Sort section, select Do Not Sort. Click OK.
Sort the row, column, or wafer labels into alphabetical order	Right-click the axis you want to sort. Select either Sort Label > Ascending or Sort Label > Descending.
Remove sorting from the row, column or wafer labels	Right-click the axis you want to revert. Select Sort Label > Do Not Sort.
Manually re-arrange column or row labels	Drag and drop labels in the column or row headings to manually re-arrange the order.
Sort wafers	Right-click a cell in the table. Select Sort Wafers > Ascending or Sort Wafers > Descending. This option is only available if the table contains a field in the wafer axis. The table wafers are sorted based on the values in the selected cell on each wafer. You can also rearrange the wafers by manually dragging and dropping the labels.

Advanced Sort Options

To access the advanced sort options, right-click a column or row and select Sort > Advanced. The Sort window displays.

Any advanced sort settings you apply persist and will be reapplied to the table if it is re-tabulated. When you re-tabulate, any other sorts that have been applied (for example by selecting Sort > Ascending, Sort > Descending or by dragging and dropping items to rearrange the table) will be overridden by the selected advanced sort.

The advanced sort settings will also be saved if you save the table as a TXD, overriding any other sort settings.

The following options are available.

Element

Description

Method

Select the sort type:

Field Sort	Sort fields independently of each other.
Axis Sort	Sort based on the axis items.

Names

Select the field to sort on (only available when Field Sort is selected).

Sort

Set the sort direction, or select Do Not Sort to revert to the default order.

Total & Derivations

Select whether totals and derivations are sorted:

First	Totals and derivations will be placed in the last position.
Last	Totals and derivations will be placed in the first position.
Sort	Totals and derivations will be sorted.

Display Items

Select this option to restrict the number of displayed items.

First Item	Select the check box and enter a value to display only the first x axis items.
Last Item	Select the check box and enter a value to display only the last x axis items.

For example, if you had a table showing customer profits in different regions, you could use this feature to show only the top three regions by profit.

Display Range

Select this option to restrict the number of displayed items based on the cross tabulation results.

Minimum Range	Select the check box and enter a value to display only items where the value is above the specified amount.
Maximum Range	Select the check box and enter a value to display only items where the value is below the specified amount.

Include 'Total' Item

Select this option to include a total of all items in the table.

Name	Enter a name for this total (for example Total).
Suppress Intersection	Select the check box to suppress the axis derivation name of the included total item in the table.

Do not use this option in conjunction with row and column totals, as it may result in double counting.

Include 'Other' Item

Select this option to include a total of all items hidden in the table (as a result of the Display Items and Display Range settings).

Name	Enter a name for this total (for example Other).
Suppress Intersection	Select the check box to suppress the axis derivation name of the included total item in the table.