How to sort column descending using column tool

[rob_vander]

Hi All,

I have one column in my model. From report view, if I click on column, from column tool ribbon I need to sort that column by another column, but it by default sort it by ascending. Is there way I can sort it by descending. ?

[Ritaf1983 · Accepted solution]

Hi @rob_vander 
Yes. You can pq sort your "Sort column " in descending order and add an index column which will be the "new sort column"
I recorded my screens, you can download the video file from This link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[rob_vander]

Creating index column is way to do it. I had to figure it out as I wanted it for Month year column.