Help Topics

Preserving Dimension Member Grouping


When you sort data, you can preserve the grouping of the dimension members on opposing axes. When you preserve grouping you ensure that the row or column organization appears as desired when sorting the data.

To preserve grouping:

  1. Right-click on a row or column header.
  2. Select Sort... from the right-click menu.
    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. The Set Sort Options dialog box will then appear.


  3. Click the appropriate radio button under Choose sort order.
    Notice that the heading in the dialog box changes depending on which member heading you right-clicked.
  4. In the Preserve Grouping on Dimensions drop down list, select a member to preserve or select Do not preserve dimension groupings.
  5. Click the OK button to close the dialog box and implement the changes.
    The grid updates immediately to reflect the changes.
    A sort indicator appears next to the member sorted on.

Related Topics: