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