4 Replies Latest reply: May 21, 2013 4:34 PM by Steve Zagzebski RSS

    Set analysis - using count distinct

    Steve Zagzebski

      I need to be able to count customers who we have sales to for at least of 2 of our products, BUT in a chart show that customer, the product and the amount of sales:

       

      Raw Data:

       

      Customer     Product     Sales

      A                 1               $10

      A                 2               $15

      A                 2               $20

      B                 1               $15

      C                 2               $20

      C                 3               $25

       

      OBJECT should look like (only showing groups with sales of at least two products and summarizing by customer by product) NOTE: Customer B is not in chart because it didn't have sales to a least 2 products

       

      Customer     Product     Sales

      A                 1               $10

      A                 2               $35

      C                 2               $20

      C                 3               $25