Show TOC

Sorting Data Locate this document in the navigation structure

Procedure

  1. Select Start of the navigation path EPM Next navigation step Edit Report End of the navigation path.
    The Report Editor opens.
  2. Select the Sorting tab.
  3. Select the Sort Data Using the Following Criteria option.
    The rest of the tab is activated.
  4. Select Member, First Column or Last Column.
  5. If you have selected Member:
    1. By default, you sort data based only on a member that is displayed in the column axis of the report. If you want to sort data based on a member that is not part of the column axis, deselect the Show Only Members Displayed in the Report option.
    2. Click the ellipsis button.
    3. In the Column Selector dialog box that opens, select the member on which the sort will be based and click on OK.
    4. Indicate whether data will be sorted in Ascending or Descending order by selecting one of the options.
    5. If you want to sort data on another member, click Add Criteria and repeat step 5.
  6. If you have selected First Column or Last Column, indicate whether data will be sorted in Ascending or Descending order by selecting one of the options.
    Note If you have selected First Column or Last Column, you cannot add criteria for the sorting.
  7. To perform the sort in each level of the hierarchy, select the Sort Inside Level option.
  8. To delete the entire sorting query, click on the Clear Expression button.
    Note If the Sort Data Using the Following Criteria option is not selected, this tab is disabled. However, if you have already entered settings, they are not deleted.