Sorting members can be accessed in the same way.

  1. Select which sorting to apply:
    • Current measure: use the measure currently used in the grid filters
    • This measure: manually define a measure to use
    • Member name: sort alphabetically by member name
    • Member key: sort alphabetically by member key
    • Hierarchize: sort members into hierarchy order
    • Reverse: reverse the default member order
    • Use measure in 'Additional members': sort by a particular measure slice
    • Member property: sort by a property defined in the cube.
  2. Select whether to sort ascending or descending. This can also be determined from an Excel range.

Keep children under parent: Select this option to ensure the children members are kept below their parent, even if the sorting would have otherwise placed them higher/lower than a higher-level member (jump to Sorting by subcategory).

Example: Sort on a different dimension

This example sorts the report in descending order of the Q3 sales.

  1. Display the Hierarchy Editor for the Product hierarchy by double-clicking on the Product label in the Grid.
  2. Under the Advanced tab, select the Sort result toolbar button ().
  3. Change the Date.Calendar selection to 2022, Quarter 3.
  4. Select the Sort Descending (9-1) radio button.
  5. Select OK. The new sort is displayed in the advanced selections tab.
  6. Select OK again to run the Report.