Sorting Month-Year by Month Name

[Anonymous]

In my chart, the data is all correct but my dimension is not sorting correctly.

=if(date(renewal_dt) <= date(GetFieldSelections(prod_dt))+182.5 and month(renewal_dt) <> month(GetFieldSelections(prod_dt)), month(renewal_dt) &' '& year(renewal_dt),

if(renewal_dt > GetFieldSelections(prod_dt), year(renewal_dt),))

This is the dimension. It displays the next six months and then after that, just the years, based on whatever production date is chosen. Attached is a snapshot of how the dimension is displayed when I sort just numerically and have 10/31/15 selected as the production date.

The years are in the correct order but the Months are not and that is what I am struggling with

[Anonymous]

Use Max({1} Month(

if(date(renewal_dt) <= date(GetFieldSelections(prod_dt))+182.5 and month(renewal_dt) <> month(GetFieldSelections(prod_dt)), month(renewal_dt) &' '& year(renewal_dt),

if(renewal_dt > GetFieldSelections(prod_dt), year(renewal_dt),))

) on Sort Expression.

Kind regards

[Anonymous]

I just noticed I still had an expression in the sort and had the box checked, this did work! Thank you so much

[sunny_talwar]

See a more detailed description did help us, right? I am glad we were finally able to resolve this.

Best,

Sunny