Tracking Daily, Weekly and YTD sales

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.

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