Forum Discussion

YunJ's avatar
YunJ
Post Prodigy
5 years ago
Solved

How to sort by two columns?

Hi, I made a matrix which is sort by GMV, but I also want make a sort for Phase, which should be first Presales, and second Bigday. Maybe I can create a new table which only contains Presales...
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI YunJ,

    You can create a calculated column to use the ISONORAFTER function to ranking multiple fields and get the rank index. Then you can use this new field as 'sort order' to achieve your requirement:

    Sorting by multiple columns  

    Regards,
    Xiaoxin Sheng