PivotTable report – Adding a Calculated Field

To add a formula (Calculated Field) as a new column in a PivotTable report:

1. Select a cell in the PivotTable report.
2. Press Alt+P to select PivotTable dropdown icon from Pivot Table toolbar, select Formulas, and then Calculated Field.
3. In the Insert Calculated Field dialog box, type the formula name in the Name box.
4. In the Fields list box, select the first field name to insert and click Insert Field. The field name is copied into the Formula box.
5. Type / (in this example), repeat step 4 to insert the second field into the formula, and then click OK.
6. To format the new field, select a cell in the field and click the Field Settings icon on the PivotTable toolbar.

This option can some times return incorrect calculation results when using multiplying or dividing.
Screenshot // PivotTable report – Adding a Calculated Field
PivotTable report - Adding a Calculated FieldPivotTable report - Adding a Calculated Field

One thought on “PivotTable report – Adding a Calculated Field

  1. Hi
    When I insert formula in calculated field A – B, A is task end time, B is task start time. But showing zero in added field in pivot table.

Leave a Reply

Your email address will not be published. Required fields are marked *

× 2 = twelve

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>