| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage calculation in pivot table | Excel Worksheet Functions | |||
| Pivot table from CSV data, problem with percentage of total. | Excel Worksheet Functions | |||
| Displaying percentage in ranges in pivot table | Excel Worksheet Functions | |||
| Pivot Table (displaying data as a percentage) | Excel Discussion (Misc queries) | |||
| How do I manipulate pivot table report to include percentage of? | Excel Discussion (Misc queries) | |||
![Victoria[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
