When working with Pivot Table, you may need to add extra calculated fields to make your Pivot Table better. For example, to add the percentage calculation between 2 columns, Pivot Table will need you to add calculated field to make it happen.
Step 1: Click anywhere in the pivot table (please see how to make a pivot table);
Step 2: Click the "Analyze" Tab from the Ribbon (or the PivotTable Analyze Tab in Excel 365);
Step 3: Click "Fields, Items, & Sets" in the "Calculations" section;
Step 4: Select "Calculated Field" from the drop-down list;
Step 5: In the new window, you need to do several things:
- Type the name of the new field;
- Select and insert the first variable from the box;
- Enter slash sign "/";
- Select and insert the second variable from the box.
Step 6: Click "OK" after and you will see a new calculated field is added to the list on the right;
Step 7: Drag this new field to the "Values" section and it will show up in the pivot table.
