Forum Discussion

Thimios's avatar
Thimios
Helper III
3 years ago

Sort date hierarchy matrix column descending

Hi all,

 

I found ways of sorting matrix column descending but only for Years. I need to make that work for Date hierarchy (Year / Short month).

All ideas will be much appreciated.

2 Replies

  • bhelou's avatar
    bhelou
    Responsive Resident

    Hello , 
    I have tried this before a year ago : 

    1 - change it to table 
    2 - to sort the columns press ALT and click on the coloumn keep the alt on to sort more than one column 
    3- cahnge it back to matrix 

    if it didnt work , dlete the matrix and do it again staring from table 

    • Thimios's avatar
      Thimios
      Helper III

      Hi bhelou ,

      I created a new table to tried that, and though I sort as desired (descending),

      when turning the Table into Matrix (Year and Short month in Columns), sorting turns back to ascending.