sort months (across columns) chronologically in a matrix

[pb202134]

Hello, 

I would appreciate some help with @sorting

I have this table

 

and i would like to sort the horizontal display of columns by month Jan to December.
The Date Table already contains a numeric column to represent the months (Calendar Month 1-12)

[mh2587 · Accepted solution]

Do it in Data tab

Select Month Name Coulmn then click on the Sort by Column in the upper ribbon Then click on Month No in the dropdown menu

[pb202134]

thank you very much @mh2587 i have successfully sorted the table chronologically by month

[mh2587]

You can Sort it with month number

[pb202134]

@mh2587 thank you, how can i see the month number option

my table above has these options, but i am not presented with the month option when tryiing to arrange the month order in the horizontal columns.
The table is currently sorted (alphabetically horizontally) and by Calendar Yeat (vertically)