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 ...
Thanks. The data exports from my ticketing system by event, which is why it's in separate sheets. The system doesn't allow me to pull daily sales reports for all events combined.
Link: https://1drv.ms/x/s!AulXG6vfEpU6_BjjWYnBYSRK3sqY?e=oXGVCH
Overview tab gives an idea of the results I want to achieve. There is likely a cleaner and more efficient way to present the data.
We hold the same events every year. I want to be able to look at my spreadsheet overview and say "we are X days out from the event. From previous years' sales data we've confidently sold X% of the total ticket sales, which means we can expect X total sales" to help with the event planning and budgeting.
Link: https://1drv.ms/x/s!AulXG6vfEpU6_BjjWYnBYSRK3sqY?e=oXGVCH
Overview tab gives an idea of the results I want to achieve. There is likely a cleaner and more efficient way to present the data.
We hold the same events every year. I want to be able to look at my spreadsheet overview and say "we are X days out from the event. From previous years' sales data we've confidently sold X% of the total ticket sales, which means we can expect X total sales" to help with the event planning and budgeting.
If you prefer a formula to copy/paste, something like
= VSTACK(
EXPAND("",30,2,""),
HSTACK(Event1tbl[% Sold], Event2tbl[% Sold])
)would bring across a couple of columns and move them down to align the days out.