3 Replies Latest reply: Apr 12, 2013 8:57 AM by Kaushik Solanki RSS

    How to count with three conditions

    Wilmar Bernal
      ATENCIONXUSUARIOEstado
      User1Cerrado
      User2Cerrado
      User3Cerrado
      User1Abierto
      User2Cerrado

       

       

      In the table you can see the example, we have the two columns, in this case i need to count the elements in 'ATENCIONXUSUARIO' column for User 1 and User 2, when the column 'Estado' is "Cerrado", according to the example the result must be 3.

       

      How can i do that???

       

      Best Regards