| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
1 for Debra? - Pivot Chart calculated field?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Calculated Field in a Pivot Table for same field | Excel Discussion (Misc queries) | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
| Pivot Calculated Field | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Threaded Mode
