Counting Unique Items

[andymowrey]

Hello,

I'm trying to figure out how to determine how many of a unique item occur per category, using the following sample database:

Bank Park

Chase Everglades

Mellon Yellowstone

Mellon Everglades

Citi Central

Chase Everglades

Mellon Central

My goal is to set it up so that I get the following info:

Bank

Mellon 3

Chase 2

Citi 1

Park

Everglades 3

Central 2

Yellowstone 1

I'm using FM 4.0 and tried doing this with subsummaries, but things never work out correctly. I've been using FM for awhile, but only sporadically and still consider myself to be a newbie. For the past two days, I've been struggling with this problem (and the manual).

TIA,

Andy Mowrey

In Pittsburgh Weekly