Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Move Pivot Charts to Separate Sheets in Excel 2013
How to Format Values in the Pivot Table in Excel 2013
How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool

How to Add Calculated Fields to Pivot Tables in Excel 2013

Step 1 of 5
Previous
Next Slideshow
Next Slideshow

Click any of the cells in the pivot table and then select the Calculated Field option from the Fields, Items, & Sets button’s drop-down list, or press Alt+JTJF.

The Fields, Items, & Sets command button is found in the Calculations group on Analyze tab on the PivotTable Tools contextual tab.

Excel opens the Insert Calculated Field dialog box.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Move Pivot Charts in Excel 2013
How to Use the Excel 2013 Quick Analysis Tool
Use Excel Pivot Tables to Get Top and Bottom Views
Create a Histogram with a Pivot Table for Excel Dashboards
How to Create Visual Reports with Power View in Excel 2013
Advertisement