Pivot Table count records for a day

[tbone56]

I have a table which has one row for every school student who is absent for a day. It shows the date, what school year they are in and their gender. I have also on each row, the "number of students" for that school year and gender. In the pivot table I need to show the absent %. I can easily average "the number of students" but how do I get the count of Students (row count) for each day.

 

[MikeL]

Hello, I placed the student name field in the values section of the pivot and then did a count of name.

 

[tbone56]

How do I delete / edit my own posts?

 

[tbone56]

Thanks MikeL, I need to rewrite this and explain it better