How to sort by two columns?

[YunJ]

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.

[v-shex-msft · Accepted solution]

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

[amitchandak]

@YunJ , As of now you can sort only on one column/measure in Matrix