1 Reply Latest reply: Mar 26, 2017 8:14 PM by Stefan Wühl RSS

    Set Analysis - how to show customers that do not own a certain product(s)

    Melissa Principe

      Hi,

      I am slowly learning about set analysis and have tried playing with the E() function but have not had any luck with this yet.  I have a data set with customers and products they own.

       

      CustomerID      Products

      1                       A,B

      2                       B,C,D

      3                       A, D, E

      4                       E, F

       

      I want to somehow filter another table/field to show CustomerIDs that do not own certain products.  For example, if the user selects Product A, I would want CustomerIDs 2 and 4 to show with their products, since they do not own Product A.

       

      Any help is appreciated.

      Melissa