Sort rows and columns

You can sort by dimension member or by data values, in either ascending or descending order. You can choose to sort respecting the hierarchy, or to sort breaking the hierarchy.

You can sort either from the menu, or by using snap commands, see Snap commands.

Procedure

  1. To sort by member, right-click either the row selector or the column selector, and select either Sort ascending or Sort descending.
    If you are using the new experience view, select Sort to see sorting options.
  2. To sort by value, select either Sort ascending or Sort descending.
  3. To sort values within a hierarchy in the dimension, right-click on the hierarchy label, select Sort hierarchical, then choose your option.
    If you are using the new experience view, you can sort values within a hierarchy under Sort.