ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Additional columns for Pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/448221-additional-columns-pivot-table.html)

Excel Dumbo

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,

Excel Dumbo

Any Help please


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com