Calculated Fields in Pivot tables - Help

[Mary]

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!

 

[Héctor Miguel]

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.