Pivot Table Calculated Fields allow you to do mathematical calculations with your Field List.  You can use any of the Excel mathematical equations, like /*+-%.

The only limitation is that you cannot reference any cells.  Pivot Table Calculated Fields can be used to calculate percentage increases on Sales, margin calculations, or Cost of Goods sold, as I show below.


Here is our Pivot Table:


STEP 1: Click on the Pivot Table and Go to Options > Fields, Items, & Sets > Calculated Field


STEP 2: Set the Name to Cost of Goods Sold


STEP 3: Set the Formula to COSTS/SALES. This is the formula to be used for our calculated field.


STEP 4: The formatting is still not correct. Right click on the new column and select Number Format.

STEP 5: Select Percentage and click OK.

Your new calculated is now ready in percentage format!


Calculated Field

Helpful Resource:


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Insert Grand Totals to a Pivot Table When you insert an Excel Pivot Table and drop a field in the Row/Column Labels you will automatically get a Grand Total. How about if you want to remove this Grand Total or show it only for a row or column? Well you have that flexibility and this is how... DOWNLOAD EXCEL...
Top 3 Excel Pivot Table Issues Resolved I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table. I want to put these issues to bed so you can go o...
Sort by Largest or Smallest With Excel Pivot Table... There are countless times when I had my Pivot Table all setup, but I was not really happy with how the data was sorted. The cool thing with Excel Pivot Tables, is it allows me to sort virtually anywhere! Let us start off with this Excel Pivot Table showing the Sum of SALES for...
Group Sales with a Pivot Table A Pivot Table allows you to Group your transactional sales values by any range that you want.  You can then summarize each sales group and see the total sales and the number of transactions that they have produced.  This is useful for pricing analysis. DOWNLOAD WORKBOOK ...