1 for Debra? - Pivot Chart calculated field?

**David** · September 27th, 2009, 05:51 PM posted to microsoft.public.excel.charting

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** · September 28th, 2009, 05:53 PM posted to microsoft.public.excel.charting

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** · September 28th, 2009, 07:32 PM posted to microsoft.public.excel.charting

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

**Herbert Seidenberg** · September 29th, 2009, 06:25 PM posted to microsoft.public.excel.charting

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode