Forum Discussion

Srinivas904's avatar
Srinivas904
Icon for Helper I rankHelper I
2 years ago
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

  • aduguid's avatar
    aduguid
    Icon for Memorable Member rankMemorable Member

     

     

    • 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.

     

     

     

    • Srinivas904's avatar
      Srinivas904
      Icon for Helper I rankHelper I

      Thank you so much, that worked. I appreciate your help.

       

      • aduguid's avatar
        aduguid
        Icon for Memorable Member rankMemorable Member

        no worries, anytime 🙂