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