Sorting Rows and Columns

You can sort rows and columns to view data in ascending or descending order. You can sort within the hierarchy or across data.

  To sort rows and columns:

Right-click a row or column member, select Sort, and then select an option:

  • Sort Ascending

  • Sort Descending

  • Honor Hierarchy: Sort within the hierarchy. If this option is not selected, sort works across data.