3 Replies Latest reply: Oct 23, 2017 4:14 AM by Dave Lau RSS

    Opposite of distinct

    Kenneth Andersen

      How do you work with distinct the opposite way?

       

      If you have data likes this:

       

       

      IDSales
      110
      220
      3100
      115
      25
      230

       

      If I like to sum Sales but only for IDs which occur twice or more. How do I do that?

       

      In this case I will get a table lieks this (ID 3 will not be summed as it only occurs once)

       

       

      IDSum of sales
      255
      325