Forum Discussion
Solved
Need a quick help on Matrix table for sorting values
Hello,
As you can see in the screenshot below, the status column is in order, but I need the values to be in descending order. When I sort by values, the order of the status column changes. Is there any way to sort only the values in descending order while keeping the status column unchanged? Please suggest any solutions.
Thanks
Srinivas
- Convert the matrix into a table.
- Sort the table by the first column. Click again to reverse the sorting order if needed.
- Add an additional sort to the table by holding Shift and left-clicking on the next column. Shift and left-click again to reverse the sorting order if necessary.
- Convert the table back into a matrix. The matrix will retain the sort orders.
3 Replies
- Convert the matrix into a table.
- Sort the table by the first column. Click again to reverse the sorting order if needed.
- Add an additional sort to the table by holding Shift and left-clicking on the next column. Shift and left-click again to reverse the sorting order if necessary.
- Convert the table back into a matrix. The matrix will retain the sort orders.
Thank you so much, that worked. I appreciate your help.
no worries, anytime 🙂
