Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculated Fields in Pivot tables - Help
Hi,
What I am trying to do is take a percentage of a value in a column I added in the data field divided by the automatic Subtotal the pivot table creates as a new row for each column. I'd like to have this formula be in a new column/calculated field. Is there anyone who knows how to do this? Or if it possible. I know you can do this by the grand total. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculated Fields in Pivot tables - Help
hi, Mary !
What I am trying to do is take a percentage of a value in a column I added in the data field divided by the automatic Subtotal the pivot table creates as a new row for each column. I'd like to have this formula be in a new column/calculated field. Is there anyone who knows how to do this? Or if it possible. I know you can do this by the grand total. one way (not by PT custom calculations): - perform your average calculations in a "helper" column next to your PT source data - use PT wizard, "back" to step 2 of 4... and add the helper column to the source range - in step 3 of 4, add your (new) average field into the data area - finish with PT wizard - in your PT, "drag" the button/title for "data" area over the "total" PT column title if any doubts (or further information)... would you please comment ? hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated fields in pivot tables | Excel Worksheet Functions | |||
Calculated fields-Pivot tables | Excel Worksheet Functions | |||
Pivot tables - calculated fields | Excel Worksheet Functions | |||
pivot tables - calculated fields | Excel Worksheet Functions | |||
Pivot Tables, calculated fields | Excel Discussion (Misc queries) |