1 for Debra? - Pivot Chart calculated field?

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
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
 
Back
Top