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 and Bigday, and add a number column, then make a relationship between these two table. But I'm wondering is there an easier way to fix this?

 

Thanks for your time.

Need Help
  • 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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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