Sorting a calculated dimensions in a chart

[#1]

I have a pivot table where I have the calculated dimension

=month&' '&year

I have dragged this dimension within the pivot table so that the month & year appear horizontally. The problem is that I cannot get it to sort by month. When I just use the month as a dimension it sorts fine.

Do I need to have an expression in Properties -> Sort?

Any guidance would be greatly appreciated.

[nathanfurby · Accepted solution]

You are creating a text field with the concatenation of Month and Year. I would suggest using the following calculated Dimension instead:

=MonthName(DateField)

This will give you the Month and Year as required but keep it in underlying numeric date format so you can choose 'Numeric Value' as sort option on the dimension.

[#3]

This worked - thanks!