Pivot Table Summary

[psamu]

I have a excel table, which has a column each row will show number of student enrolled, and another column name of student attended. I want get the percentage of attendance based on enrollment. Problem I am having is Number of student enrolled repeated in each row. I have to take only once and name I have to count in order to get the percentage. Eg. number of studnet attended count =6/10 . Thank you for the help