Forum Discussion
Solved
sorting matrix
Hello, I would like to sort matrix table by Year and then by value for each Country. How to do it? Country Year Value Belarus 2024 19099 Belarus 2025 19023 Belarus 2023 17596 Paraguay 2024...
Ania26 Sorry I just took another look at your picture and now I get what your issue is. You're currently sorting by the Value descending but actually want the dimensions ascending, right?
Your current version probably looks similar to this:
Hi Ania26, I'd just flip the two fields used in "Rows", so you group first by year, then by country:
vs
Hello, thank you but I want to see first Country and then Year
Ania26 Sorry I just took another look at your picture and now I get what your issue is. You're currently sorting by the Value descending but actually want the dimensions ascending, right?
Your current version probably looks similar to this:
