If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
1 for Debra? - Pivot Chart calculated field?
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 |
#3
|
|||
|
|||
1 for Debra? - Pivot Chart calculated field?
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 |
#4
|
|||
|
|||
1 for Debra? - Pivot Chart calculated field?
Excel 2007
OLAP based PivotTable Workaround for calculated fields. Generic data. http://www.mediafire.com/file/zgnkdimktvm/09_29_09.xlsx |
Thread Tools | |
Display Modes | |
|
|