Pass/Fail rate calculation in pivot table

[choks90233]

I am looking to add a measure for my pivot table that will do a simple pass fail rate calculation. The calculation is =pass/sum(pass, fail) how do I translate that into pivot table language? There are 4 basic criteria I am working with. Inspection ID, Date/time, Eval Area, and Rate Status. The date and Eval Area are used as filters for the pivot table. The Inspection ID is the value, and Rate status makes up the rows. There are 4 possible inputs for Rate Status. Fail, Not Rated, Observation, and Pass. So I need to add the number of passes to the number of fails, then divide that total by the passes to get the pass rate. As an example below I created a filtered view of similar data I am using. There are six total inspections. Three Passes and one fail which equals a 75% pass rate. Can I get my pivot table to do that calculation for me?

Inspection ID	Date	Eval Area	Rate Status
1	1-Jan-20	Component installation	Pass
2	15-Jan-20	Component installation	Pass
3	30-Jan-20	Component installation	Not rated
4	1-Feb-20	Component installation	Fail
5	15-Feb-20	Component installation	Observation
6	22-Feb-20	Component installation	Pass

 

[sandy666]

could you show expected result?

 

[choks90233]

The desired result is a pivot chart that shows pass rates instead of just passes and fails. I do not know how to get the pivot table to calculate that formula to create a data point for the pivot chart