Subtract colums in pivot table

D

Domenick

I have a pivot table that has the following characteristics (Excel 2007):
-rows (down the left) are values: "# Employees", "Total Pay"
-Columns (across top) are Dates

I want to calculate the difference between different date columns.

Example:

I have:

Date
5/23/2010 5/16/2010 5/24/2009 Total
# Emp 10 15 5 30
Pay 1000 15000 500 16500

I'd like:

Date
5/23/2010 5/16/2010 5/24/2009 Total Vs. Last Wk % Change Vs. Last Yr % Change
# Emp 10 15 5 30 -5 -33% 5 33%
Pay 1000 5000 250 6250 -4000 -80% 750 15%


Can anyone tell me how to create these columns? The dates will change each
week, but it will always be the difference of col 1 vs col 2 and col 1 vs col
3.

Please let me know if this is unclear or you need more info. Thanks

(PS Not sure how this will display on the board. If there is a trick to
posting excel data into these messages so that it lines up correctly, please
share! Thanks.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top