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.

DOWNLOAD EXCEL WORKBOOK

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:

728x90

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Pivot Charts & Slicers In a previous post I showed you how to Insert a Pivot Chart.  Now we will take this concept once step further and insert a Slicer.  The cool thing about this is that the Slicer will control both the Pivot Table and the Pivot Chart. See how you can start creating some awesome i...
Protected: What Else Can Excel Pivot Tables Do?  The Pivot Table Webinar Replay & Xtreme Pivot Table Online Course is Closing its Doors in... Click Here To Watch The Webinar Replay BONUS VIDEO:   Consolidate Multiple Sheets & Excel Tables In this training you are going to learn the following:C...
Show The Percent of Grand Total With Excel Pivot T...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF GRAND TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sal...
Conditionally Format a Pivot Table With Data Bars Data Bars are a new Conditional Formatting feature in Excel 2010 and they add a colored bar to your values. The length of the data bar represents the value in the cell.  A longer bar represents a higher value. You have a Gradient Fill or a Solid Fill to choose from as well ...