Forum Discussion

caantjes's avatar
caantjes
Frequent Visitor
10 years ago

Sort on multiple columns

  I have several reports created where it would be nice to sort on multiple columns.  For example (1) number of orders decreasing year and month or (2) seqenced by weeks the number of tickets for ea...
Need Help
caantjes's avatar
caantjes
Frequent Visitor
10 years ago

Hi Qiuyun

 

It would be in your example to sort the territory groups in DESC alphabetical order and the territory region in ASC alphabetical order. You would define subsequent sorts on colums to allow for either reading.  In MS Excel more advanced configuration is available.

 

Let me know if this helps.

 

Thanks.

 

Corne

 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi caantjes,

 

Do you mean you want to get a feature like Custom Sort in Excel? Currently, in a table visual, we need to set sort order for each column one by one. For your requirement, please post feedback and vote on this idea item: Custom Sort Lists.

 

Best Regards,
Qiuyun Yu