Now I want to modify the formula by increasing the bonus to 3 percent. Create the Percentage Change Column. Then on Options tab of the PivotTable Tools ribbon click Fields Items Sets.
First select any cell in the pivot table.
Click the arrow in the Name box and. Calculated Fields can be arrived at by using formulas and existing fields of the data table. To delete a calculated item select the item and click Delete under Add. This has been a guide to the pivot table to add a column.