7 Replies Latest reply on Oct 23, 2017 8:05 PM by Deepak Rai

    Count Customers that only purchased product A not Product B and count customers that purchased A and B.

    L L

      So I am trying to count three different metrics.

       

      Count customers that only purchased 'Product 1'

      -This will exclude customers that did buy 'Product 1' but also purchase other products. So if they purchased 'Product 1' but also in a different order they purchased 'Product 2' they will not be counted.

       

      Count customers that only purchased 'Product 2'

      -This will exclude customers that did buy 'Product 2' but also purchase other products.  So if they purchased 'Product 2' but also in a different order they purchased 'Product 1' they will not be counted.

       

      Count customers that purchased 'Product 1' and 'Product 2'

      -This will only include customer that bought both 'Product 1' and 'Product 2' no other products

       

      I have included a very basic example workbook, but can work out the general idea. This seems really easy but for some reason I can put it together in my head.