Change month order

[MartinConroy]

Hi,
I'm looking to compare values across months year by year. This I have working basically, but our financial year runs Oct-Sep, so wondered how I could change this chart to start with Oct and run to Sep?
Thank you!

[MartinConroy]

Thank you - this example was most helpful. I was struggling because I was basing the month on the month part of a date hierarchy field. Once I explicitly stored the month number all was fine 🙂

[amitchandak · Accepted solution]

@MartinConroy , You need to create a month sort column, assume you have this column in date table

month sort = if(month([date]) <10 , 3+ month([date]) , month([Date]) -9)

mark this as the sort column of the month

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c