Hi Jason,

If you use the Field Summery to select the field called "Schools".  The change the summary type to "Unique", that should give the answer I think you are looking for.

Thanks Dominic, that is useful to know but its a little more complicated its seems.

The 'school, field on the project is a lookup field so I don't get the option of unique. It seems that option is only available on the primary field. 

Any other ideas/work arounds ?

Are you able to share more details? The Summary type options available are dependent somewhat on the data type, so depending on the field type you are looking up, there could be times that you may not find this option.

Here I am looking up a single line text field and Unique is an option:

Hey Dominic, I have moved on from the project and no longer have access to the base. I managed to work around it by finding other unique fields on the record that worked (email address).

I need to replicate the scenario and play around to determine what can and can't be rolled up with unique records. I'll post back if I find anything but I really appreciate you help.