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.