Forum Discussion

Ania26's avatar
Ania26
Icon for Helper IV rankHelper IV
10 months ago
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...
Need Help
  • KarinSzilagyi's avatar
    KarinSzilagyi
    10 months ago

    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:

     

     

KarinSzilagyi's avatar
KarinSzilagyi
Icon for Super User rankSuper User
10 months ago

Hi Ania26, I'd just flip the two fields used in "Rows", so you group first by year, then by country:

vs

 

  • Ania26's avatar
    Ania26
    Icon for Helper IV rankHelper IV
    10 months ago

    Hello, thank you but I want to see first Country and then Year

    • KarinSzilagyi's avatar
      KarinSzilagyi
      Icon for Super User rankSuper User
      10 months ago

      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: