Ok, look into using =getpivotdata()

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

Else, copy paste special values (probably on another sheet; certainly on
another sheet if you need that PivotTable to be a PivotTable) and then do the
calculation in a column to the right of the data set.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"David" wrote:

To simplify my problem, my source data table has 3 fields:
Job#, CreatedPeriod, CompletedPeriod
eg: 32, 200901, 200904
Field 1) I have CreatedPeriod as a row area field
Field 2) I have count of CreatedPeriod as a data (column) field
Field 3) I have count of CompletedPeriod as a data (column) field
Field 4) I have item (2) again as cumulative - show data as running total in
field (1)
Field 5) I have item (3) again as cumulative - show data as running total in
field (1)
I need another field, "Cumulative Outstanding". This is Field 4 minus Field 5
I've tried all sorts but no joy yet
please help