Counting Summary Occurances

[stublito]

This may be newbie, but I can't get it. In a standard summary report with 3 Summary Parts:

Country

State

City

Body is

Person

How do I count the number of (separate) countries, States and or Cities for the persons being browsed (If two people live in the same city, the city only gets counted once etc).

Thanks

Peter

[comment]

See if this helps:

http://www.fmforums.com/forum/showpost.php?post/297916/

[stublito]

Thanks. That appears to only work for the top "level" of the summary. I'll try some variations.

Peter

[comment]

You have to repeat the last 2 fields for the subcategories.

[stublito]

I tried that with a straight substitution of field definitions for the other 2 but it doesn't work. FYI the sort matches the GetSummary field definitions, so that's not it.

I someone could whip up a quick demo file, that would be awesome.

THANK YOU.

Peter

[comment]

Here's an example that counts groups and subgroups - hopefully you'll know how to extend it further down.

CountSubGroups.fp7.zip

[stublito]

Wow, THANK YOU.

I should be able to figure it out from here,

Peter