I need to create a chart that has rolling years and periods
I've managed to create varaibles for the Periods 1 to 12 but I need to create another variable for the year
Another complication is that the periods and years are not aligned to calendar period and years
So:
Aug = 01 through to July = 12
This is what I've created for the periods, but what I need now is a variable that allows be to roll the year when the period is = August. I'm then want to call the variables so that I can return a value for each period in multiple years
