Creating cross-hierarchical sorting with custom MDX
See Examples
This expands the aggregate elements in a dimension to show all its elements without any hierarchical structure. It sorts their captions in descending order.
- In the List Designer create a new sorting criterion and select Custom MDX as the type.
- In the Edit Custom MDX dialog, enter [Product].CurrentMember.name,BDESC