Additional columns for Pivot table

E

Excel Dumbo

Hello

Attached is a pivot table with multiple consolidation ranges.
I would like to insert two additional columns names them Growth (201
over 2011) and Growth (2012 over 2011)

Growth(2012 over 2011) will be dividing values in Column D by Column
values
Growth (2013 over 2012) will be diving values in Column G by Column
values

I would like the additional calculated columns to appear at the end o
the pivot table - in column H and column I

I had trouble attaching the file to this wensite, hence uploaded on t
the link below

http://speedy.sh/SHusj/Insert-Calculated-Field-in-Pivot-table.xls




please kindly guide me


Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Batch Pivot Table update 0
How to ignore a column of numbers in Grand Total for rows 1
Pivot table 2
Pivot table - show monthly data based on start/end date data 0
A calculated item gives unwanted changes to my pivot table 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table Difference Columns 0
Mystery field in pivot table 5

Top