I have a chart which is meant to show Dimension - Month Names and the measures. shown below
I am using a Field Called KeyDate (a number) and using a calculated Dimension =Text(Date(KeyDate,'MMM')) which returns the Month.
I don't want to use the function Month Name as I don't want the Year appended after the month E:g I want Jan instead of Jan 2014. The reason being Series 1 is for Year 2014 and Series 2 is for Year 2013.
Now the problem is that when I use the above function QV is sorting them as
Dec, Jan, Feb .... Nov
I have tried using Sort by Numeric and that doesn't seem to do the trick. I also tried using Sort by expression where my expression is
Month(KeyDate) which I expect would return an integer for the month. No luck.