How To Add a Column To Pivot Table Where one Column Is Percent of Another Column

[pmolema]

I have created a pivot table showing following information:

Row Labels	Correct Qty	Incorrect Qty	Total Qty
Whs1	8798	1287	10085
Whs10	867	287	1154
Whs11	897	88	985
Whs12	658	166	824
Whs13	898	390	1288
Whs14	787	378	1165
Whs15	598	451	1049
Whs2	589	67	656
Whs3	587	41	628
Whs4	257	12	269
Whs5	987	95	1082
Whs6	888	99	987
Whs7	879	177	1056
Whs8	558	156	714
Whs9	987	197	1184
Grand Total	19235	3891	23126

<tbody>
</tbody>

In this I would like to add a new column "% correct" which is basically the row value from column "Correct Qty" / Grand Total from column "Total Qty". I have tried many things but don't seem to solve it. How to create a new column where the row value is divided by the grand total of another column.

 

[jarjarbingie]

I have created a pivot table showing following information:

Row Labels	Correct Qty	Incorrect Qty	Total Qty
Whs1	8798	1287	10085
Whs10	867	287	1154
Whs11	897	88	985
Whs12	658	166	824
Whs13	898	390	1288
Whs14	787	378	1165
Whs15	598	451	1049
Whs2	589	67	656
Whs3	587	41	628
Whs4	257	12	269
Whs5	987	95	1082
Whs6	888	99	987
Whs7	879	177	1056
Whs8	558	156	714
Whs9	987	197	1184
Grand Total	19235	3891	23126

<tbody>
</tbody>

In this I would like to add a new column "% correct" which is basically the row value from column "Correct Qty" / Grand Total from column "Total Qty". I have tried many things but don't seem to solve it. How to create a new column where the row value is divided by the grand total of another column.

can you provide a sample of how the data source looks like?

 

[DHayes]

Hi,
hope fully this will help. follow the below as to how to add your percentage column in your pivot table.
1. Options Tab
2. Go to Fields, Items & Sets
3. Select Calculated Field
4. In The name give your field your name e.g Percentage.
5. in the formula select Correct Qty divide by total Qty
6. It should look something like this.
='Correct Qty'/ 'Total Qty'


Then put you percentage into your totals and format to %
Hope this will help.