5 Replies Latest reply: Oct 22, 2013 2:02 AM by Tormod Hanstad RSS

    Count a count expression?

      CustomerSport
      ARugby
      AFootball
      ATennis
      ACricket
      BFootball
      BTennis
      CFootball
      DTennis
      ERugby
      FTennis
      FFootball
      GTennis

       

      Hello, what I want to do is count the number of times a customer only has 1 sport against them, regardless of what the sport actually is. So customer A has 4 sports against them, customer B has 2 sports against them, Customers C-E have only 1 sport against them, customer F has 2 sports against them and customer G has 1 sport against them. So the answer is 4 (only 4 customers have only one sport against them). Essentially its a count of a count, but I have no idea how this is done. Any help will be much appreciated.

       

      Thanks,


      Ralph