Difference between 2 calculated fields showed as % of grand total

D

dot238

I have an issue in my workbook.

I've created a pivot containing values for 2011 and for 2012 in different categories. I have added 2 calculated fields to show the share. The calulated fields contain the values and I have selected "Show values as % of grand total". This gives me the share.

Now I would like to show the difference between the share in 2011 and the share in 2012. When I create a calculated field "share2012-share2011" it uses the values (instead of the share) and only shows me the difference between the values and not the share.

Example:

20112012Share2011Share2012Evol
ProductA1000110015%17%it shows me 100 but it should be 2%

Any idea how to get the correct value?
 

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

Difference between 2 calculated fields showed as % of grand total 0
Additional columns for Pivot table 0
How to ignore a column of numbers in Grand Total for rows 1
Calculating FED TAX in Excel 0
Assistance need to populate "GRAND TOTAl" "MSpivottable11" in Microsoft web component 0
Return a value when Date x is between Date y and z 1
Date subtraction 1
Need a little help with a custom function 1

Top