Yes, it is possible to set up the pivot table to display the division of 2 cells of data in the same row. Here are the steps to add the
% Shipped column to your pivot table:
- Select the pivot table and go to the "PivotTable Analyze" or "Options" tab in the ribbon.
- Click on "Fields, Items & Sets" and select "Calculated Field".
- In the "Name" field, enter "% Shipped" or any other name you prefer.
- In the "Formula" field, enter "= Sales Shipped / Sales Ordered".
- Click "Add" and then "OK".
- The new calculated field will be added to the pivot table as a new column.
Now you should see the
% Shipped column in your pivot table, which displays the division of Sales Shipped by Sales Ordered for each salesperson. The
% Shipped column will automatically update as you make changes to the pivot table.