Creating intra-hierarchy sorting with custom MDX
This example is based on the Samples application, which can be enabled in on-premises environments. It uses a hyperblock created from the Product dimension.
This sorts the captions of the children in descending order. The All Tires element remains at the top of the list and the hierarchical structure of the list is kept.
- In the List Designer select as the sorting criteria.
- Specify [PRODUCT].CurrentMember.name,DESC.