Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago
Solved

Sort Matrix Columns Descending Order

Hi all,   How can I sort columns in descending order? I tried moving the index to Rows, sorted descending and then moved back to columns but it reverted to Ascending order Thanks, -w  
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    Hi UncleLewis

     

    I assume your 1,2,3,4,5 to 12 column headings are months

    In the query editor add a column called revmonthsrt = [month] * -1

    to create -1,-2,-3,-4,-5 to -12

    then in modeller sort month by revmonthsrt 

     

    your report will then dislay column headings decsending 12,11,10,9,8 etc

     

    Please click thumbs up and accept as solution buttons. Thanks. ğŸ˜€ 

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago

Thanks speedramps 

 

I tried the reverse item, didn't change the order on the visual. Tried Asc and Desc.


I tried to remove all columns and added index column from Date Table - Matrix columns are Asc

I went to Data View and sorted the Index Column Desc.
I went back to Report View. Matrix Columns are still in Asc order

What am I doing wrong?

Thanks,
-w