3 Replies Latest reply: Mar 23, 2017 10:45 AM by Melissa Principe RSS

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

    Melissa Principe

      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!