Use Excel Pivot Tables to Get Top and Bottom Views
How to Use the Excel 2013 Quick Analysis Tool
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

COMMENTS »
blog comments powered by Disqus
How to Move Pivot Charts to Separate Sheets in Excel 2013
How to Move Pivot Charts in Excel 2013
Create a Histogram with a Pivot Table for Excel Dashboards
How to Format Values in the Pivot Table in Excel 2013
How to Pivot a Table’s Fields in Excel 2013