I've been tracking my company's daily sales for years in a manually formatted Excel table, but I was recently introduced to PivotTables. For the most part they seem great, but I'm having trouble setting up the PivotTable to track daily, weekly, and YTD sales. I've managed to setup the PivotTable to show my daily sales in columns (Mon., Tues., Wed., etc...) and then the automatic Total column adds up the daily sales to arrive at my sales for that week. Now, I would like to have one more column tacked onto the end of the chart that shows my YTD sales for each price point.
Any advice would be very welcome. Please let me know if I can supply more info on what I'm looking for. I was trying to be as concise as possible.
I've pasted an example of my raw data and ideal pivottable below.
thanks!
raw data sample:
w/e date day description # tix $ tix
9/30/2007 9/24/2007 Monday Full Price 100 $1000
9/30/2007 9/24/2007 Monday Premium 200 $4000
9/30/2007 9/25/2007 Tuesday Full Price 150 $1500
10/7/2007 10/1/2007 Monday Full Price 200 $2000
Ideal PivotTable:
we 10/7/2007
Monday Tuesday Wednesday Total Week Total YTD
Full Price
Premium
Total Total Total Total Total
Any advice would be very welcome. Please let me know if I can supply more info on what I'm looking for. I was trying to be as concise as possible.
I've pasted an example of my raw data and ideal pivottable below.
thanks!
raw data sample:
w/e date day description # tix $ tix
9/30/2007 9/24/2007 Monday Full Price 100 $1000
9/30/2007 9/24/2007 Monday Premium 200 $4000
9/30/2007 9/25/2007 Tuesday Full Price 150 $1500
10/7/2007 10/1/2007 Monday Full Price 200 $2000
Ideal PivotTable:
we 10/7/2007
Monday Tuesday Wednesday Total Week Total YTD
Full Price
Premium
Total Total Total Total Total