How to add a percentage column in a Pivot Table

V

Victoria

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.
 
N

Nikki

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
 

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