I'm trying to create a running sum with YoY tracking. This seems like it would be simple, but my timeframe is 13 months so it's becoming complex. I'm graphing the bookings that are happening now for activities happening during the holiday period (Dec/Jan). So the bookings are taking place 13-0 months before the cutoff.
Here's what my data looks like on a weekly and running total level, but I need to view this Year over Year. Figure 2 shows what the data looks like when i use a week number. There first 4 weeks of the year are inflated, because they actually have two years worth of data.
I think it's possible to create a fix using this using the advanced table calculations, but I can't figure this out. Figure 4 is what i'm trying to recreate from excel, but this took manual work.
FYI - this summer is referring to the Australian Summer. I'm hoping to not confuse anyone
I played with this a bit - I changed the Fiscal Start Date to December from January for the Booking Date field. Do this by right clicking on the field and selecting 'Default Properties" - then create the view for just the years desired with the running total.