View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mwillie15 Mwillie15 is offline
external usenet poster
 
Posts: 3
Default Formula inside a Pivot Table

Inside my raw data I have a series of sku's with qty sold (units) and sale
date (2007 and 2008) as follows:

SKU A 2 2007
SKU B 3 2007
SKU A 4 2008
SKU B 2 2008

When I create a pivot table, I have the sku as the row header and the two
years as the column headers. How can I calculate a thrid column that would
represent the difference? In the calculate field menu, I cannot figure out
how to create a formula that will calculate a result data that origninally is
in the same column.

Any suggestions?

mwillie15