How to Get Percentage of Two Columns in a Pivot Table

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.

Leave a Reply