View Single Post
  #1   Report Post  
Excel Dumbo Excel Dumbo is offline
Senior Member
 
Posts: 105
Default 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,