In this case, we’ll use the name “Unit price”. The Insert Calculated Field dialog box will be displayed.įirst, type the name of the Field you’d like to create.
Then, on Options tab of the PivotTable Tools ribbon, click “Fields, Items & Sets”. To add a calculated field to a pivot table, first select any cell in the pivot table. We could add a new column to the source data that calculates unit price by dividing total sales by quantity, but we can also add a unit price as a calculated field.
However, the data does not contain a unit price. If we check the source data, we see that we have columns for quantity and total sales.
This pivot table shows sales data by product. Adding a calculated field to a pivot table is an alternative to adding a new column to the source data.
