In the dialog box, assign a name to your calculated field and input your formula using the field names from your data. Click OK to add the calculated field to your PivotTable.

Learn Excel 365 calculated columns to enhance your data analysis skills with dynamic formulas, cross-table calculations for real-time insight Skip to main content Skip to secondary menu ...

Note that the walkthrough and video were made using Microsoft Excel 365 for Pcs. Other versions of Excel may work differently. Excel’s auditing tools are found, fittingly enough, on the Formulas tab ...