My pivot table is setup like this:
Name.........Pass..........Fail.........Total
Joe.............3...............1.............4
Nancy.........4...............1.............5
Where the Pass and Fail numbers are actually one field (QC Result) broken out by the two values that populate that field, Pass or Fail. The pivot table then added the Total column at right as a simple sum.
In trying to add a calculated field, Excel is only letting me divide one existing field in the list by another existing field in the list. But the data on which I want to calculate is actually from one field, QC Result. I would like to do the following formula: (Count=Pass / Total Count).
And ideally would like it to show as a single column to the right of the "Total" column.
Am I missing something here, or do I need to setup my pivot table another way?
Bookmarks