5 Replies Latest reply on Jun 14, 2019 1:24 PM by Ken Flerlage

I'm noodling with sets for the first time. It seems like they largely function as database views. I know how I'd do this with Access, SQL, and Excel, but I'm trying to avoid those.

I'd like to use each set in the workbook as an 'AND' such that I only pull men who've won each of the four majors. (See the sets.) Jack and Tiger appear in all four because they won all four. Rory McIlroy wouldn't appear in the final set because he's yet to win the Maters.

I created four sets. The in/out filter is not working—probably because I don't understand what it's trying to do.

Thanks in advance. I suspect that I'll say this after someone posts how to do this:

• ###### 1. Re: Question about Sets

I'm a bit confused...the workbook doesn't have any sets in it.

• ###### 2. Re: Question about Sets

In any case, I feel like sets aren't the best approach to this problem as you'll find yourself manually maintaining the sets. If you want to know who's won all four majors, then I'd suggest a calculated field like this:

Won All Four?

// Did the player win all four?

// Determine this by counting the unique tournaments won.

IF {FIXED [Winner]: COUNTD([Tournament])}=4 THEN

TRUE

ELSE

FALSE

END

You can then filter where this field = TRUE.

• ###### 3. Re: Question about Sets

Sorry. I uploaded the wrong workbook.

• ###### 4. Re: Question about Sets

Your way is so much more elegant. Thank you!

• ###### 5. Re: Question about Sets

I do see what you were trying to do now though, but as noted above, the other solution makes more sense. The biggest problem with the sets is that you'll have a level of detail problem. The set membership will be "IN" only for that given tournament, so to determine if a player was "IN" in all four sets, you'll need to do an LOD for each tournament, which just makes it all that much more messy.