crosstab - Excel 2010 - percent on filter value -

I have found this type of database:

  NAME answered the question Brian Q1 Yes Brian Q1 wrong Brian Q1 no Brian Q1 Yes Brian Q2 Yes Brian Q2 Yes Brian Q2 wrong John Q1 Yes John Q1 Yes John Q1 No John Q1 Yes John Q2 No John Q2 Yes John Q2 wrong  

I want to calculate a percentage of "yes" for each question in Excel 2010 in a cross tab Make.

The result should be like this:

  Question name Q1 Brian 50% 66% John 75% 33%  

My Meaning: Brian responded 4 times the question Q1. He answered "yes" 2 times, thus the percentage of the thousands answered is 50% (2/4 * 100).

How can I do this in a cross table? I answered NAME on lines, questions on columns, and prices. Know that if someone adds a filter on the answer, then the percentage calculated by Excel is only on filtered values, not the total question Q1. Add a fourth column with

formula = IF (c2 = "yes", 1.0) . After this, in the "value" section of PivotTable, and calculates the average (which is instead of the default), calculates.