How to Sort Members in a Table

You can change how dimension, account, or measure members are sorted, including keeping members grouped when there are multiple dimensions on a row or column.

There are a few ways to sort dimension members in a table:

Keeping rows or columns grouped.
Value sorting.

For more information, see Value Sorting.
Default order.
A-Z (or lowest to highest).
Z-A (or highest to lowest).
Custom Order.

For more information, see Changing Member Order.

Keep Members Grouped

When you have multiple dimensions on a row or column and you sort on the innermost dimension, you can decide whether to keep the row or column sort results grouped together.

Restriction

The member grouping options are only available for SAP acquired data models and SAP HANA live data connections.

The grouping status (Keep Left Columns Grouped, Keep Top Rows Grouped) can only be changed in the following situations:

You've selected the dimension header of an inner row or column dimension.
Ascending or descending sort has been applied.
Hierachies are set to Flat presentation.

Example: Grouping Option Enabled or Disabled

In the following examples, the phrase regarding member grouping refers to both options: Keep Left Columns Grouped and Keep Top Rows Grouped.

Example

You have a Profit and Loss model with the following measure and dimensions:

Type	Name
Dimension	Product
Dimension	Region
Measure	Income Statement

Sort on Product (A-Z) with the Keep Members Grouped Option Enabled

Region	Product	Income Statement (millions)
New York State	Basics	0.63
New York State	Juices	16.97
New York State	Soft drinks	16.14
Ohio	Basics	0.06
Ohio	Juices	2.22
Ohio	Soft drinks	1.69
Pennsylvania	Basics	0.25
Pennsylvania	Juices	5.94
Pennsylvania	Soft drinks	7.24

Sort on Product (A-Z) with the Keep Members Grouped Option Disabled

Region	Product	Income Statement (millions)
New York State	Basics	0.63
Ohio	Basics	0.06
Pennsylvania	Basics	0.25
New York State	Juices	16.97
Ohio	Juices	2.22
Pennsylvania	Juices	5.94
New York State	Soft drinks	16.14
Ohio	Soft drinks	1.69
Pennsylvania	Soft drinks	7.24