View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Victoria[_2_] Victoria[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.