Difference between 2 calculated fields showed as % of grand total

  • Thread starter Alexandre Snoeck
  • Start date
A

Alexandre Snoeck

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:

2011 2012 Share2011 Share2012 Evol
ProductA 1000 1100 15% 17% it shows me 100 but it should be2%

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
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
Date subtraction 1
Need a little help with a custom function 1
Pivot Table Grand Total Issue 3
Grand Total for a calculated column - Access 2007 1

Top