|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com