Forum Discussion
Change month order
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 , 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
2 Replies
- amitchandak
Super User
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 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 🙂
