Show TOC

To sort membersLocate this document in the navigation structure

Procedure

  1. Select a cell in the crosstab that belongs to the dimension you want to use for sorting.
  2. Choose Start of the navigation path Sort Next navigation step More Sort Options... End of the navigation path.
    The Sort by dialog box appears.
  3. Select the sort option you want to use:
    • Sort Ascending

      Sorts members from A to Z.

    • Sort Descending

      Sorts members from Z to A.

  4. In the Sort by list, select the object type for sorting:
    • Default (Dimension Members by First Display Type)

      The members are sorted by the first display type of the selected dimension.

    • Member Display Type

      You can select one of the member display types in the list below.

    • Measure

      If you select this object type, you can select one of the available measures in the list below. With this object type, the sorting is applied to the values of the selected measure and not to a dimension.

    Note If you do not want to change these settings, you can also select the sorting options Sort Ascending and Sort Descending directly in the menu or context menu.
  5. Select Break Hierarchies if you want to sort the members across hierarchies. Existing hierarchies in the crosstab and their subtotals are not available any more after sorting.
  6. Press OK.

Results

The sorting is applied to the crosstab.