How To Do A Calculation In A Pivot Table?
Add a calculated field Click the PivotTable. On the Analyze tab, in the Calculations group, click Fields, Items, & Sets, and then click Calculated Field. In the Name box, type a name for the field. In the Formula box, enter the formula for the field. Click Add. Can you do math in a pivot table? […]