Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to custom sort the matrix

I have following fact table-

based on this table I designed following matrix-

now I need to sort the matrix based on Availability.
The order should be - Platinum, Gold, Silver, Lead.

I tried sorting it onmy own, but no luck.
Thanks.

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You need to create a sort column

     

    Availability 1 = [Availability]

     

    Availability Sort = Swiitch([Availability],

    "Application Availability - Platinum" ,1

    //  Add other ,

    //Add default

    )

     

    Sort Availability 1  on Availability Sort and use that.

    Refer : https://www.youtube.com/watch?v=KK1zu4MBb-c

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , You need to create a sort column

     

    Availability 1 = [Availability]

     

    Availability Sort = Swiitch([Availability],

    "Application Availability - Platinum" ,1

    //  Add other ,

    //Add default

    )

     

    Sort Availability 1  on Availability Sort and use that.

    Refer : https://www.youtube.com/watch?v=KK1zu4MBb-c