Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table custom/calculated field?
To simplify my problem, my source data table has 3 fields:
Job#, CreatedPeriod, CompletedPeriod eg: 32, 200901, 200904 Field 1) I have CreatedPeriod as a row area field Field 2) I have count of CreatedPeriod as a data (column) field Field 3) I have count of CompletedPeriod as a data (column) field Field 4) I have item (2) again as cumulative - show data as running total in field (1) Field 5) I have item (3) again as cumulative - show data as running total in field (1) I need another field, "Cumulative Outstanding". This is Field 4 minus Field 5 I've tried all sorts but no joy yet please help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table custom/calculated field?
Ok, look into using =getpivotdata()
Example he http://www.contextures.com/xlPivot06.html Else, copy paste special values (probably on another sheet; certainly on another sheet if you need that PivotTable to be a PivotTable) and then do the calculation in a column to the right of the data set. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "David" wrote: To simplify my problem, my source data table has 3 fields: Job#, CreatedPeriod, CompletedPeriod eg: 32, 200901, 200904 Field 1) I have CreatedPeriod as a row area field Field 2) I have count of CreatedPeriod as a data (column) field Field 3) I have count of CompletedPeriod as a data (column) field Field 4) I have item (2) again as cumulative - show data as running total in field (1) Field 5) I have item (3) again as cumulative - show data as running total in field (1) I need another field, "Cumulative Outstanding". This is Field 4 minus Field 5 I've tried all sorts but no joy yet please help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table custom/calculated field?
Thanks Ryan
I'm still struggling. I have a pivot chart linked to my table. It is essential that my new field is within the pivot table (to feed the pivot chart). The new field needs to be the difference in value of 2 custom (running total) pivot fields. Any idea? Thanks "ryguy7272" wrote: Ok, look into using =getpivotdata() Example he http://www.contextures.com/xlPivot06.html Else, copy paste special values (probably on another sheet; certainly on another sheet if you need that PivotTable to be a PivotTable) and then do the calculation in a column to the right of the data set. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "David" wrote: To simplify my problem, my source data table has 3 fields: Job#, CreatedPeriod, CompletedPeriod eg: 32, 200901, 200904 Field 1) I have CreatedPeriod as a row area field Field 2) I have count of CreatedPeriod as a data (column) field Field 3) I have count of CompletedPeriod as a data (column) field Field 4) I have item (2) again as cumulative - show data as running total in field (1) Field 5) I have item (3) again as cumulative - show data as running total in field (1) I need another field, "Cumulative Outstanding". This is Field 4 minus Field 5 I've tried all sorts but no joy yet please help |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table custom/calculated field?
Ryan
Your patience is truly appeciated i'll send you an email tomorrow with an attached .xls file I failed to mention that my source data is coming from a MS Access database Hope this does not screw the solution? (My "client" needs a chart with a live feed from the access db) "ryguy7272" wrote: Well, I think the ideas I gave you should work. If you want to send me an email I'll take a look at it and get back to you. Please explain explain exactly what you want; more detail is better. Thanks! Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "David" wrote: Thanks Ryan I'm still struggling. I have a pivot chart linked to my table. It is essential that my new field is within the pivot table (to feed the pivot chart). The new field needs to be the difference in value of 2 custom (running total) pivot fields. Any idea? Thanks "ryguy7272" wrote: Ok, look into using =getpivotdata() Example he http://www.contextures.com/xlPivot06.html Else, copy paste special values (probably on another sheet; certainly on another sheet if you need that PivotTable to be a PivotTable) and then do the calculation in a column to the right of the data set. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "David" wrote: To simplify my problem, my source data table has 3 fields: Job#, CreatedPeriod, CompletedPeriod eg: 32, 200901, 200904 Field 1) I have CreatedPeriod as a row area field Field 2) I have count of CreatedPeriod as a data (column) field Field 3) I have count of CompletedPeriod as a data (column) field Field 4) I have item (2) again as cumulative - show data as running total in field (1) Field 5) I have item (3) again as cumulative - show data as running total in field (1) I need another field, "Cumulative Outstanding". This is Field 4 minus Field 5 I've tried all sorts but no joy yet please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
Pivot table, IF function, calculated item versus calculated field | Excel Discussion (Misc queries) | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Formulas Calculated Item / Calculated Field | Excel Programming | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) |