How do we do? I dont know, could you help with pivot table?

Also as far as ı detail in sheet 2, before chart or pivot table, there should be number of people from Sheet 1 automatically. (table reguire e formulas for calculation also.) Then pivot table should be done.