Hi All,
I have a document which is trying to work out the total percentage of rejections from a list.
Here is a picture of my data
And this is the Pivot table at current
As you can see it's summing the percentages which is not what I want to achieve.
For example, Supplier A - Chocolate. It has summed 5% of 100 and 5% of 200 and given a figure of 10% total rejection which is incorrect (It's summed the %figures).
What I want it to do is give me the actual figure for percentage rejected based upon Total Rejected/Total Recieved *100.
Many thanks for any help you can provide.
Farmertml
I have a document which is trying to work out the total percentage of rejections from a list.
Here is a picture of my data

And this is the Pivot table at current

As you can see it's summing the percentages which is not what I want to achieve.
For example, Supplier A - Chocolate. It has summed 5% of 100 and 5% of 200 and given a figure of 10% total rejection which is incorrect (It's summed the %figures).
What I want it to do is give me the actual figure for percentage rejected based upon Total Rejected/Total Recieved *100.
Many thanks for any help you can provide.
Farmertml