Columns Sorting issue for matrix table

[kelvin-lkh]

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.

[kelvin-lkh]

@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!

[danextian]

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