Using the Sort tool

By default, each hierarchical dimension is sorted before it is displayed in the query results and after each time you change the selection. For hierarchical dimensions, you can use the Sort tool to turn automatic sorting off or to change the rules that the tool uses for sorting the dimension values.

For nonhierarchical dimensions, you can use the Sort tool to sort the dimension values or to turn on automatic sorting for the dimension.

To sort dimension values:
  1. In the Selector dialog box, choose the Sort tool from the Selector toolbar.

  2. Complete the Sort Selection dialog box. Be sure to select the Sort Automatically box if you want to have the dimension values sorted each time the selection changes.

  3. Choose OK.

See also

Selector toolbar