4 Replies Latest reply on Jul 28, 2015 12:09 PM by Alexander Mou

    Distinct Count of Client by Product/Service

    Marcia Tatay

      I need to be able to get a distinct count of clients that purchased Product A only, Product B only, and Both Product A & B.  It seems like a simple ask, but alas, the answer has alluded me.

      I am attaching a sample data set with two products.  Any help would be appreciated.

       

      Example:  Each line is an order.  Client A would be in the both category, Client B would be in the Product A category, and Client C would be in the Product B category.

      My distinct count would then be:

      Product A     1

      Product B     1

      Both A&B     1

      Header 1Product AProduct B
      Client A1
      Client B1
      Client C1
      Client B1
      Client A1