Re: What is a suitable Set Analysis expression for distinct counts based on condition/groupings
Yes, I agree, but I have many multiples of members across the 5,000 entries. Precisely, there are 623 unique members across the 5,000 records. Nearly all are in one or the other Division (Region East or Region West).
I know there are a few members that belong to multiple areas in both Divisions - these are the ones I'm trying to trap and produce a distinct count of those members so that we don't count them more than once.