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.