I have tables for Events, Contacts, and Schools. (There are about 12 other tables but not relevant to this)

The Events are related to the Contacts (multi-select)

The Contacts are related to the Schools (more than one student can be associated with the same school.

My goal is a view or report that lists the event and the NUMBER of students from each school that attended the event.

So it would show:

Event Name, Number of students associated with School #1, Number of Students associated with School 2, etc.

I tried using a rollup field but am lost on the proper setup.

Any help with as many specifics as possible would be appreciated.