Creating intra-hierarchy sorting with custom MDX

See Examples

This sorts the captions of the children in descending order (the All Tires element remains at the top of the list). The hierarchical structure of the list is kept.

  1. In the List Designer select Custom MDX as the sorting criteria.
  2. Enter [PRODUCT].CurrentMember.name,DESC.
Parent topic: Examples