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

2 replies

null
    • Lead Software Engineer
    • Vijayan_Krishnan
    • 1 yr ago
    • Reported - view

    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.

    • Michael_Raam.1
    • 1 yr ago
    • Reported - view

    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

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 50Views
  • 3 Following