Forum Discussion

kelvin-lkh's avatar
kelvin-lkh
Frequent Visitor
3 years ago

Columns Sorting issue for matrix table

Hi all ,

 

I have a matrix table below and the columns is by years. I want the order of the columns is sort by FY20, FY21, FY22, Budget. However, the sequence of the columns always give me the Budget in front. Even I create a table to add in the Index and then use the sort by index function but the result is still the same.

 

Can anyone advise how I can get the columns to be sorted in the way I wanted? Thanks for the advice in advance.

 

 

 

 

 

 

 

Need Help

2 Replies

  • danextian's avatar
    danextian
    Super User
    3 years ago

    Hi kelvin-lkh 

    Columns in a matrix are sorted alphabetically unless sorted by another column. Since B come first in the alphabet and so does in your matrix. Try sorting Year column by Index column so Budget comes last

     

  • kelvin-lkh's avatar
    kelvin-lkh
    Frequent Visitor
    3 years ago

    danextian Thanks for your input. I thought there is a way to work around this restriction but looks like I need to redesign the naming of the column to overcome this issue. 

     

    Thank you for the advice!