Change Month Dimension Sort Order in Chart

[danielle_v]

Hi All,

I have a line chart where the dimension is Month. Naturally, the sort order of this is Jan-Dec.

However, I'd like to change the sort order so that the months run from Sep-Aug. Is this possible?

The reason I'd like to do this is because my fiscal year runs from Sep-Aug - in the script, year is defined as right(yearname(DateField,0,9),4)

Any help greatly appreciated!

[tresesco · Accepted solution]

try this:

Sort by expression (ascending):

Expression like: match(MonthField, 'Sep', 'Oct', 'Nov', 'Dec',....,'Aug')

[danielle_v]

Perfect, many thanks for your help!!