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:
![]() |
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. |