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.

  1. In the List Designer select Custom MDX as the sorting criteria.
  2. Specify [PRODUCT].CurrentMember.name,DESC.