8 Replies Latest reply on Jul 9, 2018 9:20 AM by chris monger

    Cross selling between two services

    Rhea Kalogeoropoulos

      Hello everyone!

       

      I have been stuck on this issue for a while now and would appreciate any insight anyone could offer!

      I have a set of services, each with different id's and a set of customers with different id's as well. I am trying to figure out between two distinct services, how many customers have purchased both service A and service B. My table sort of looks like this:

       

      As you can see Users with Id "1" and "21" have purchased both services 1 and 2. I want to be able to see the number of users that have acquired both services, which in this case is 2. Thank you in advance for any feedback.

      Service IdUser Id
      11
      4
      10
      21
      21
      3
      8
      15
      21