Sorry, I did as instructed but I think I'm missing something fundamental here. Please see the attachment, I'm still not able to group the data points according to the states.
There seems to be no sub-summary part – or if there is one, it doesn't appear because you haven't sorted the found set (or not sorted it by state)..
There are a number of free videos on youtube to show you how to develop subsummary reports:
filemaker sub summary - YouTube
Retrieving data ...