Calculated Fields in Pivot tables - Help


M

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!
 
Ad

Advertisements

H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top