Pivot Table Custom Calculations

Giganews Newsgroups
Subject: Pivot Table Custom Calculations
Posted by:  misses99
Date: Wed, 9 Jul 2008

Hi All - Pivot Table newb here...i have a pivot table that is formatted
something like this:

.......................... ITEMS SOLD
REGION....AREA.....APPLES......ORANGES.....GRAPES...TOTAL
Canada....East..........10.............20.............15.........45
...............West.........15.............17.............19.........51
Total Canada............25.............37.............34.........96

Europe.....England.......5.............15.............20.........40
................Italy..........10.............10............10.........30
Total Europe..............15.............25.............30........70

What i would like to do is add a custom field that would calculate a
specified percentage of the TOTAL.  For Example:
- 10% of the Apples
- 15% of the Oranges
- 20% of the Grapes
So it would look something like this:

.......................... ITEMS SOLD
REGION....AREA.....APPLES......ORANGES.....GRAPES...TOTAL
Canada....East..........10.............20.............15.........45
...............West.........15.............17.............19.........51
Total Canada............25.............37.............34.........96
CALCULATED %........2.5...........5.55...........6.8.......14.85

Europe.....England.......5.............15.............20.........40
...............Italy..........10.............10............10.........30
Total Europe.............15.............25.............30........70
CALCULATED %.........1.5...........3.75...........6.0.....11.25

Is this possible?

Appreciate your valuable feedback!

Replies