Not sorting months correctly

[CSmith]

I am using this expression, Coalesce(sale_month_n,max({<sale_year = {"$(=Max(sale_year)-1)"} >} sale_month_n)). It works to sort the months correctly if I select the current year. Any other year selected the months are not being sorted correctly.

[Chanty4u · Accepted solution]

Try this 

Max({<sale_year = {"$(=Max(sale_year))"} >} sale_month_n)

In sorting tab enable numeric sorting and use below expression 

Dual(sale_month_n, Month(Date#(sale_month_n, 'MMM')))

[CSmith · Accepted solution]

Thank you!! I figured it out already. But when I used your expression it also works.