I'm having an issue calculating the overall pass rate for the month. You'll notice the grand total includes the observation count, which I don't want it to. The observations subtract .5% from the pass rate to get the true pass rate for the month. IE: =SUM(Pass/Total)-(Observation*0.005). How can i get this added/corrected in the pivot table so I can develop a corresponding chart?
Data.jpg
Bookmarks