Sort on member / Remove sorting

You can sort rows or columns in the grid.

To sort members:

  1. Right-click a row or column in the grid and select Sort on Member.
  2. Select from:
    Option Description
    Ascending / Break Hierarchy This command sorts all cells numerically in ascending order.
    Ascending / Preserve Hierarchy This command sorts cells in ascending order within their hierarchy. For example: France, Germany, and Italy would be sorted within the Europe hierarchy, while Japan, China, and Singapore would be sorted within the Asia hierarchy.
    Descending / Break Hierarchy This command sorts all cells numerically in descending order
    Descending / Preserve Hierarchy This command sorts cells in descending order within their hierarchy. For example: France, Germany, and Italy would be sorted within the Europe hierarchy, while Japan, China, and Singapore would be sorted within the Asia hierarchy.
To delete a sort, right-click the row or column and select Remove Sorting.