Matching Sales Day by Day Comparison with previous Festivals

Hi all,

I have a table and graph created that show the ticket value and ticket count for the current festival and previous years (2016 onwards).

However, I am trying to change them so it shows the ticket value and count for the previous years but with the matching day to where we are now.

For example, today is Day 37 of our current festival sales period. I would like the previous years to show their value and count for Day 37 of their sales, not their total like they currently are.

If possible in the table as well, I am aiming to show the value and count for "yesterday" across every year. So where as the graph will show Days 1 to 37 inclusive for each year, the table will show that but also the value and count for Day 36 alone.

This would then update Day by Day automatically.


I have made sure the on sale date for each year is the same across every event.

Any help here would be appreciated.

Image below of what I currently have to give you an idea of how I am aiming to have them laid out.

Cheers