How To Create A Calculated Field In Excel?
To add a calculated field: Select a cell in the pivot table, and on the Excel Ribbon, under the PivotTable Tools tab, click the Options tab (Analyze tab in Excel 2013). In the Calculations group, click Fields, Items, & Sets, and then click Calculated Field. Click Add to save the calculated field, and click Close. […]