1 Reply Latest reply on Nov 19, 2018 3:47 PM by Hari Ankem

    Count the number of times a client has bought 2 products

    Amit Gupta

      I have seen examples of this where the product is within a single column, but how is this handled when the product is essentially their own column.

       

      In the example that I have uploaded, I have a dimension called Product (row Pill) and what I am trying to do is a count of clients that have Linear + search

      or Linear + DigA.   When I add a condition where Product = Search and Product = Linear it fails as each row in the underlying database only mentions one product at time.   If try and change to an Or statement i am massively over counting.

       

      Thank You