Search for answers here or ask a question
0

Sort a hierarchy using multiple measures

Hello everyone,

I feel this should be straightforward but struggling to implement. I would like to sort a hierarchy by multiple measures, so that there is a primary measure used for sorting, a secondary measure and so on.  Anyone have an idea of where to find some documentation to achieve this.

Cheers, Dave

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • In Sort Wizard / Sort Targets you can do the multiple sort by select the measures based on your choice.

    Hope this is the one you are looking for.

    Like 1
  • hi,

    Consider the option to create a special sort measure that will be based on the other measures and produce the needed sort order.

    Example:

    [Sort measure] = [measure A] * 10000 + [measure B] * 100 + [measure C]

    and use [Sort measure] in the sort.

    Tnx,

    Michael

    Like 2
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 2Replies
  • 32Views
  • 3 Following