Forum Discussion

hill's avatar
hill
Helper I
5 years ago
Solved

Sort in Matrix

I have this matrix, and I find that I can only change the sorting of stock_name and Total  by click them, as you can see the small triangle below. But I also want to see the sorting of addition, new...
Need Help
  • lkalawski's avatar
    lkalawski
    5 years ago

    Hi hill

    If in the Columns field (in matrix seeetings) you have added a field with the values "addition", "new", "reduction" and "soldall", unfortunately this columns cannot be sorted.
    To enable sorting, you need to create a separate measure for each 'category' and then add it in the Values field (in the matrix settings).



    _______________
    If I helped, please accept the solution and give kudos! 😀

lkalawski's avatar
lkalawski
Resident Rockstar
5 years ago

Hi hill

If in the Columns field (in matrix seeetings) you have added a field with the values "addition", "new", "reduction" and "soldall", unfortunately this columns cannot be sorted.
To enable sorting, you need to create a separate measure for each 'category' and then add it in the Values field (in the matrix settings).



_______________
If I helped, please accept the solution and give kudos! 😀

  • hill's avatar
    hill
    Helper I
    5 years ago

    Thanks and it works well!