When I use a Expression to Sort a field, Position is changing

[#1]

Hi Guys,

I have Month name and want to sort it by Month Number.

So when displaying I am displaying Month Name and when in sort using expression MonthofYear which is nothing but number 1 to 12.

It is working fine but position is changing when i select any month. For example If I select Jan, Jan will be star displaying at the end.

I don't want this want to freeze the position of each value  like Jan Feb to Dec.

Please see screenshot attached

[Gysbert_Wassenaar · Accepted solution]

Sort by the expression only({1}MonthofYear) instead. The {1} will prevent the selection from influencing the sort expression.

[#3]

Gysbert,

Thank you. It works