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 ...

HOW TO: Options ribbon -> Formulas -> Calculated Fields. A dialogue box opens up where you can name a new field and then create the formula to generate this new calculated field.