3312855 - Cannot change order of the displayed measures when using hierarchies and selecting an specific node

How to display the hierarchies and dimensions in an specific order (sorting behavior) if just a node of the hierarchy is required and not its main node.

SAP Analysis for Microsoft Office.

1. Open the required query in AO;
2. Go to the Design Panel -> Right click on Measures -> Filter by Member;
3. Select the members you wish to sort its order;
4. Once the data is filtered, sort the dimensions as required and place the main node of the hierarchy where you wish to have the secondary (or other levels) node;
5. In order to have just the secondary (or other levels) node displayed in the required order, perform the steps below:
   1. Select the hierarchy to be used;
   2. Click on Hierarchy option -> Show Levels;
   3. Untick the levels before the one you want to have it displayed and which is placed in the middle of the dimensions, as required;
6. The results should be displayed as required.

In order to have just the secondary (or other levels) node displayed in the required order, perform the steps below:

1. 1. Select the hierarchy to be used;
   2. Click on Hierarchy option -> Show Levels;
   3. Untick the levels before the one you want to have it displayed and which is placed in the middle of the dimensions, as required;

hierarchy, Show Levels, display, measures, dimension, sorting, order, node, parent node, child node. , KBA , BI-RA-AO-XLA , Excel Addin , How To