Calculations using multiple items from the same field in a pivot table?

[zsdazey]

I have spent a lot of time searching for an answer to this, but no luck. I'm sorry if this is in the wrong place, this is my first post here.

I have a sheet with raw data (first table). Each row contains a person's name (each person appears multiple times, and there are over 30,000 rows currently). There are three columns to the right, which contain either "Yes","No","N/A", or are blank:

Employee	Criteria1	Criteria2	Criteria3
Person 1	Yes	Yes	No
Person 2	No	Yes	Yes
Person 1	Yes	Yes	Yes
Person 3	Yes	N/A	No

<tbody>
</tbody>

After creating a pivot table with the data, I put the "Employee" field in row labels, and "Criteria1" in both column labels and values, returning this:

Employee	No	Yes	Grand Total
Person 1		2	2
Person 2	1		1
Person 3		1	1

<tbody>
</tbody>

Instead, I want the pivot table to only show percentages for each criteria, and an average of all 3 percentages. Percentages should be calculated as the "Yes" number divided by the "Grand Total," to look like this:

Employee	Criteria 1	Criteria2	Criteria3	Average
Person 1	100%	100%	50%	83.33%
Person 2	75%	75%	25%	58.33%
Person 3	100%	75%	50%	75.00%

<tbody>
</tbody>

I can get the "Yes" column in the pivot table to display as "total percentage of current row," which is the correct percent, but every time I try to add more criteria it adds a ton of other columns I don't need.

How would I go about creating this pivot table?