1 for Debra? - Pivot Chart calculated field?

[David]

I have a pivot chart with x axis as months (200901, 200902, etc.)
Y axis is jobs count
pivot table is reading an access db (field 1 = job#, field 2 = CreatedMonth
field 3 is CompletedMonth)
Pivot Chart fields:
1 Row field: month created
2 Colum data field: count of month created
3 Column data field: count of month completed
4 Colum data field: count of month created - running total in months
5 Colum data field: count of month completed - running total in months
All is working well so far...
What I need is a running total for cumulative outstanding
ie: running total of month created minus running total of month completed
(field 4 minus field 5)
Any suggestions will be much appreciated

 

[Herbert Seidenberg]

Excel 2007
OLAP based PivotTables do not support:
Calculated fields/items
Page field settings
Data field function changes
Show Pages
Show items with no data
Subtotal hidden page items settings

 

[David]

Thanks Herb

No chance eh?

 

[Herbert Seidenberg]

Excel 2007
OLAP based PivotTable
Workaround for calculated fields.
Generic data.
http://www.mediafire.com/file/zgnkdimktvm/09_29_09.xlsx