Forum Discussion

msogge's avatar
msogge
New Member
2 years ago

How to sort by values within a column

Hello,

 

I am trying to figure out how to allow users an option to sort values in my matrix table by the values themselves, instead of by column. Below is the Matrix I am using:

As can be seen, it is possible to sort "Major" (my rows) alphabetically. However, I'd also like users to be able to sort by % and # (which are measures), largest to smallest. Currently I am unable to do so. When I remove my column ("Year"), it allows me to sort them, but Year a a crucial component of this matrix so I do not want to get rid of it.

 

Is there a way to allow users to sort by values within a column, similar to how row currently has that sort option?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi msogge 

    You can sort the visual by the mesaure, click sort by measure, and you can set the sort order :ascending or descending. You can refet to the following picture.

    Best Regards!

    Yolo Zhu

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