Forum Discussion
Sales figures by day from multiple tabs averaged in to a summary?
Hi there, I analyse ticket sales data and want to be able to see, from historical sales-by-day data, the average % of total sales on any given number of days prior to the show. I've put the ...
OK, I understand. Assuming that you can add two columns to the event tables (Event number and Year), you can easily combine all events in one larger table. Automate it with Power Query or Copy/Paste manually if there aren't that many events. Whatever is easier for you.
Anyhow, you'll create a table like in the attached file which you can then analyze with a pivot table. Note that I just copied Event 1 three times into a new table numbering them 1, 2 and 3.
Riny_van_Eekelen that is fantastic, thank you!!