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:

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

    • Sort Ascending: View information in ascending order, from lowest to highest.

    • Sort Descending: View information in descending order, from highest to lowest.

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

  2. To stop any sort operations in the data form, click Cancel Sort.