14 Replies Latest reply: Feb 15, 2018 11:34 AM by Sunny Talwar RSS

    How to Count and Group By

    Jaime Arroyo

      Hello World!

       

      Please I need help to get the number of valid products (State) that a customer has on the company and group by ID

       

      I have this table

       

      ID -  PRODUCTS ID - STATE

      15363 - VEHICLE - VALID

      15363 - MOTO - INVALID

      15363 - VEHICLE 2 - VALID

      14321 - VEHICLE - INVALID

      14321 - VEHICLE 2 - VALID

       

      I need to get this

       

      ID - NUMBER OF PRODUCT VALID

       

      15363 - 2

      14321 - 1

       

      Thanks