Use Custom Sorting

You can use the custom sort options to override the default sorting behavior. For example, you can sort items based on a measure other than the default measure, or based on a row or column other than the summary values of the opposite axis. The custom sort options also let you sort by attributes.

By default, items in nested sets are sorted based on the values of the innermost nested row or column. You can use custom sorting to sort nested or stacked sets differently than this default.

For an example of custom sorting, see Example - Perform a Custom Sort.

Before you begin

You must select a set to perform a custom sort.

Note: When a selection-based set contains members from different levels, sorting the set by an attribute that is not common to all levels may result in a server error.

Similarly, if you append a member from a different level to a selection-based set that is sorted by attribute, the same error may occur.

Procedure

  1. Select a set.
  2. Click the sort button sort icon on the toolbar, and click Custom.

    The Sort dialog box opens.

  3. Under Sort order, select Ascending or Descending.
  4. Under Options, select whether to sort
    • Based on the column or Based on the row

      You can change the defaults as needed.

    • Based on attribute
  5. Click OK.
    Tip: To remove a sort or restore the default order, click No Sort.
Parent topic: Sort Values