How to add a percentage column in a Pivot Table
 

Hello,

I often create various pivot tables that contain sales information by
product and time range. How can I add a third column that calculates
percentage growth %.

Ex.
Pivot table

Group 1 Group2 2007 2006 %
Apples Green 100 50 100.0%
Red 125 135 -7.4%
Orange 75 0 #DIV/0!
Apples Total 300 185 62.2%
Bannana Green 200 210 -4.8%
Orange 220 205 7.3%
Brown 565 532 6.2%
Bannana Total 985 947 4.0%

Thank you.

How to add a percentage column in a Pivot Table
 

there are 2 way to do this:
1. in your underlying data add an extra column wich calculates % growth and
include that in your Pivot (this won't work if you want to see the grwoth by
groups)

2. insert a formula:
got to Pivot table menue, select formulas--calculated field-- add
(2007-2006)/2006 as a formula..you should see another coul. in your table
that would calc. growth.

hope this helps.

Nikki

"Victoria" wrote:

Hello,

I often create various pivot tables that contain sales information by
product and time range. How can I add a third column that calculates
percentage growth %.

Ex.
Pivot table

Group 1 Group2 2007 2006 %
Apples Green 100 50 100.0%
Red 125 135 -7.4%
Orange 75 0 #DIV/0!
Apples Total 300 185 62.2%
Bannana Green 200 210 -4.8%
Orange 220 205 7.3%
Brown 565 532 6.2%
Bannana Total 985 947 4.0%

Thank you.