How to insert calculated fields in PivotTable

Uploaded time: November 16, 2021 Difficulty Intermediate

A free Office suite fully compatible with Microsoft Office

Free Download

How to insert calculated fields in PivotTable

How to insert calculated fields in PivotTable

Take this sales performance table as an example. We want to generate a new column, sales commission based on this PivotTable. (Tips: Sales commission is equal to sales amount multiplied by 0.08.) So, how do we do that?

First, we click the Options tab, and the Fields, Items drop-down button, select Calculated Fields, then the Insert Calculated Fielddialog will pop up.


In the Name edit box, input Sales commission. In the Fields area, choose Sales amount. In the Formula edit box, input *0.08. And click OK to add the calculated field of sales commission.


If we want to delete the Sales commission calculated field, select any cell under that field, right-click to pop up the shortcut menu and select the Remove Sum of Sales Commission option.


Did you get it?

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.