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.

  1. In the List Designer create a new sorting criterion and select Custom MDX as the type.
  2. In the Edit Custom MDX dialog, enter [Product].CurrentMember.name,BDESC