Sorting OLAP Dimensions

In the OLAP section, data can be sorted in ascending or descending order.

  To specify a sort:

  1. Select an item to sort in the OLAP sections.

  2. Select either Sort Ascending or Sort Descending on the shortcut menu.

  3. Select Label to sort the item alphabetically, or select the numeric value item as a sort reference.

  4. If you select a numeric value, choose an aggregate function on the Function shortcut menu.