WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How to insert calculated fields in PivotTable

Uploaded time: November 16, 2021 Difficulty Intermediate

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.