Calculated Fields in Pivot tables

Calculated Fields in Pivot tables - Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mary - 25 Mar 2008 19:52 GMT

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!

Reply to this Message

Héctor Miguel - 25 Mar 2008 23:29 GMT

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 to this Message