Forum Discussion

suvechha's avatar
suvechha
Helper IV
4 years ago

Sort by column in the visual matrix . ?

Hi All,

I have a matrix with Day Month as column and all the other as values - How can I sort the Day Month Ascending ?


 




I dont have any option to sort by Day Month .

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    suvechha , In Nov 2021, few options are added. Else you can create a new column with a new sort

     

    Month Date = [Date Month]

    Month Date Sort = format([Date], "MMDD")

     

    If needed create rank

    Month DateRank = rankx('Date',[Month Date Sort])

     

    Mark them Month Date Sort or Month Date Rank as sot column of the new copy column and use that

     

    How to Create Sort Column and Solve Related Errors:
    https://www.youtube.com/watch?v=KK1zu4MBb-c