Sort Selection dialog box

Use the Sort Selection dialog box to sort dimension values in a selection. The methods of sorting you can use depend on the dimension's properties.

Dialog box components

The available components vary according to the current dimension and the options you select.

Based on box -- Lists the sorting methods, as follows:

In hierarchy box -- When you choose Data Value, Hierarchy, Level, or Time in the Based On box, the In Hierarchy box lists the hierarchies that are defined for the selected dimension. Select the hierarchy that you want to use.

In order box -- Lists the sort-order options for the Alphabet, Database, Data Value, Hierarchy, Level, and Time methods.

Script box -- Displays the criteria that will be added to the selection script if you choose OK.

Preview button -- Displays the Preview dialog box, which allows you to examine the change you are considering and lists the dimension values that will be selected if you adopt the change.

Sort automatically check box -- Specifies whether the dimension is sorted automatically each time the selection changes.

See also

About selecting Express data

Replacing or refining a selection

Selector toolbar