Procedure
- Select a cell in the crosstab that
belongs to the dimension you want to use for sorting.
- Choose
.
The
Sort by
dialog box appears.
- Select the sort option you want to
use:
- In the
Sort by
list, select the object type for sorting:
- Default (Dimension Members by
First Display Type)
The members are sorted by the first display
type of the selected dimension.
- Member Display Type
You can select one of the member display
types in the list below.
- Measure
If you select this object type, you can
select one of the available measures in the list below. With this object type,
the sorting is applied to the values of the selected measure and not to a
dimension.
Note If you do not want to change these
settings, you can also select the sorting options
Sort Ascending and
Sort Descending directly in the
menu or context menu.
- Select
Break
Hierarchies if you want to sort the members across hierarchies.
Existing hierarchies in the crosstab and their subtotals are not available any
more after sorting.
- Press
OK.
Results
The sorting is applied to the
crosstab.