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,