Help with set analysis - select accounts that own only certain product(s)
I have a data set like the following:
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.
Re: Help with set analysis - select accounts that own only certain product(s)
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.