Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Additional columns for Pivot table
Hello
Attached is a pivot table with multiple consolidation ranges. I would like to insert two additional columns names them Growth (2012 over 2011) and Growth (2012 over 2011) Growth(2012 over 2011) will be dividing values in Column D by Column C values Growth (2013 over 2012) will be diving values in Column G by Column D values I would like the additional calculated columns to appear at the end of the pivot table - in column H and column I I had trouble attaching the file to this wensite, hence uploaded on to the link below http://speedy.sh/SHusj/Insert-Calcul...ivot-table.xls please kindly guide me Regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Additional column formula in pivot table | Excel Discussion (Misc queries) | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
an additional pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Please respond: Need to create additional measure in pivot table | Excel Discussion (Misc queries) |