Help Topics

Sorting Data in the Grid


You can sort data in ascending or descending order in the grid. When None is selected, the data is displayed according to the Member Filter selections. The data sorting feature is available from the grid's right-click menu. If the menu bar or toolbar is available in the application, the sorting option can be accessed via the Data > Sort ... menu item in the menu bar or the Sort buttons ( The Sort Ascendingly buttonand The Sort Descendingly button) in the toolbar.

  1. Right-click on a row or column heading.
  2. Select Sort....
    The Set Sort Options dialog box appears.
    Note

    If you right-click on a data cell and select Sort..., the Choose Header Cell dialog box appears, requiring you to select a dimension member to sort on. Select a dimension member, and click OK.


  3. Select the Ascending, Descending, or None radio button.
  4. Select a Preserve grouping on Dimension option for the drop down list.
    This option only appears if multiple dimension members are displayed in the grid.
  5. Select whether to preseve hierarchy.
    When the Preserve hierarchy check box is checked, keeping members with their parents after the sort operation.
  6. Click the OK button to close the dialog box and implement the changes.
    The grid updates immediately to reflect the changes.
Tip

Whe you click the Apply button the changes are implemented but the dialog box remains open.

Note

Sorting works only on a single dimension at a time; it does not work with multiple dimensions selected.


Related Topics: