View Single Post
  #4   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can use the 'Difference From' custom calculation. There's an example
here, using two years. You could use days instead:

http://www.contextures.com/xlPivot10.html#DiffFrom

And there are instructions here for turning off the Generate
GetPivotData featu

http://www.contextures.com/xlPivot06.html

Cheryl B. wrote:
This seems easy enough - and have figured out a quick & dirtly way - but need
to get it into a formula.

'Created a pivot table and need to calculated the difference between two
columns ... e.g. Monday has 11 widgets and Wednesday has 16 widgets ...
what's the increase?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html