Return to FileMaker.com
Number of gropus
I have 2 main tables: Person Place and 1 join table: Move
Move table is simple with fields:
Person::Name Place::City Place::Country Date
I have a report grouped by Place::Country and sorted by Place::City.
Each group shows ammount of persons in group and I have a Total Summary of persons in the footer.
But I need also a number of Groups in the footer.
If you are using FileMaker 12 or newer, you may be able to set up ExecuteSQL to get the total: A new way to count unique values in FileMaker 12
Another option, which is a bit involved to set up, is called "summing the reciprocal": How to count the number of unique occurences in field.
Retrieving data ...