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

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

Thanks Herb

No chance eh?

"Herbert Seidenberg" wrote:

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

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