I'm using Excel 2003. I'm a high school guidance secretary. The
administrators are constantly asking for data relating to course failures.
From our school's student management program, I've exported a listing of all
course grades for the year and used the data to create a pivot table.

Right now, I'm only using row fields: StuName, GradeLVL, TermID, StoreCode,
Course, Grade

I've filtered the data to only show records with a TermID of '1901' &
'1900'. (Semester 1 Final or Year Long). I've also filtered the StoreCode to
only show records with a StoreCode of 'S1'. I've filtered to Grade data to
only show records with a grade < 75. (Course Failures)

My delima is that I need to show ONLY records for students with two or more
course failures. Currently, I'm sorting through the records and hiding the
rows for students with only one course failure. It seems like there should
be a way for Excel to calculate this data for me, but I don't know how in the
Pivot Table.

Can you help?

Thanks!