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:
Honor Hierarchy: Sort within the hierarchy. If this option is not selected, sort works across data.
Scripting on this page enhances content navigation, but does not change the content in any way.