Help with set analysis - select accounts that own only certain product(s)

[maprinci]

Hello,

I have a data set like the following:

AccoutNum    Product

1                       A

1                       B

1                       C

2                       A

2                       D

3                       A

4                       C

4                       E

4                       F

I am interested in getting the total number of accounts that own only Product A or only Products A and C, etc.  When I use a filter for Product and select A, I get all accounts that own Product A but also potentially own other products.  Basically,  I need to isolate groups of products where an account owns nothing but the product(s) I select.  Any help is appreciated.

Thanks!

[ahaahaaha · Accepted solution]

Hi Melissa,

See attached file. Maybe something like this?

Regards,

Andrey

[maprinci]

Thank you, Andrey!

[maprinci]

Andrey,

Do you know of a way to easily update this to also display only accounts that do not own certain product(s)?  I would want the user to be able to select a product and have only accounts that do not own that product appear with the products they do own.  I have tried using the E() function in a few different ways but have not gotten anything to work yet.

Thank you,

Melissa