Sorting Columns

Depending on the screen you are viewing, two methods are available for sorting columns:

  To sort using the Member Selector:

  1. On the screen, click the Member Selector Member Selector at the top of the column that you want to sort.

  2. From the drop-down list, select Show Grid.

    This step removes the hierarchical format to enable sorting.

  3. On the screen, click the Member Selector Member Selector again, and choose the sort option that you require:

    • Ascending (from lowest to highest)

    • Descending (from highest to lowest)

    • Default (as displayed in the Essbase database)

    The list is redisplayed using the selected sort option.

  To sort using the Column Header:

  1. On the screen, double-click the column header to display the sort icon:

    • Ascending sort icon Sort icon ascending to sort the entries alphanumerically, from lowest to highest.

    • Descending sort icon Sort icon descending to sort the entries alphanumerically from highest to lowest.

  2. Double-click the column header to toggle between sort options.