Sort - Month(Date)&'-'&Year(Date)

[Raju_6952]

Hi All,

I am using Month(Date)&'-'&Year(Date) expression in my dimension in bar chart and i want it to be sorted Month and then year wise, Ex-

Jan-13, Feb-13.. and so on.

I see that the expression has been sorted properly but for some reason Oct-2013 and Nov-2013 is getting displayed at the end after Sep-2017.

Please help me get this fixed.

Thanks,

Raju

[Raju_6952]

Hi All,

I am using Month(Date)&'-'&Year(Date) expression in my dimension in bar chart and i want it to be sorted Month and then year wise, Ex-

Jan-13, Feb-13.. and so on.

I see that the expression has been sorted properly but for some reason Oct-2013 and Nov-2013 is getting displayed at the end after Sep-2017.

Please help me get this fixed.

Thanks,

Raju

[rwunderlich]

Try instead to create your dimension as 

=Date(MonthStart(Date), 'MMM-YYYY')

and then check Numeric for Sort type. 

-Rob