Pivot Table Custom Calculations

M

misses99

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!
 

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