Report, counting the number of unique values in a field
I need to generate a report (using Filemaker Pro 11) where the number of unique values of a particular field are counted. (Specifics: Multiple schools participating in multiple events; I need a count of the number of schools participating. If a school participates in multiple events, it is just counted once.)
I'd appreciate any help in how to do this. The "!" to find duplicates isn't much help. I tried "omitting" "!", but that doesn't help either.
Thanks for any ideas.