Forum Discussion

Thimios's avatar
Thimios
Icon for Helper III rankHelper 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.
Need Help
bhelou's avatar
bhelou
Icon for Responsive Resident rankResponsive Resident
3 years ago

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
    Icon for Helper III rankHelper III
    3 years ago

    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.