Hi guys, new to the forums so go easy on me!

So I have two data sets to do with a persons list and whether or not such persons have completed a survey.

The first set involves a collection of persons as a whole, and the second set involves a group of persons (who are also included in the first set) who belong to a certain group. So in the two data sets, I have a list of the names and a column which has the value 'Yes' if they have completed it and blank if they have not. I need to create a pivot table which compares both sets of data as currently both results are on two separate sheets.


First data sets looks as follows:

Name Completed Percentage Completed: X% (Countif for 'Yes' in completed column)
John Smith 1 Yes
John Smith 2
John Smith 3 Yes
...

Second data is the same but for a particular group of persons.

So I need a pivot table that I can then produce a comparison with that states the percentages of both and then I can plot via graph or something.

If you could help that would be greatly appreciated! Thanks in advance!