How to count with three conditions

[#1]

ATENCIONXUSUARIO	Estado
User1	Cerrado
User2	Cerrado
User3	Cerrado
User1	Abierto
User2	Cerrado

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

[#2]

Hi,

Try with this:

Count({< ATENCIONXUSUARIO={User1, User2} >} Estado)

If the result is different, try to include the DISTINCT Clause:

Count({< ATENCIONXUSUARIO={User1, User2} >} DISTINCT Estado)

Regards,

Ricardo

[#3]

Thanks for your answer.

With the expression that you suggest we can only count the items that contains User1 and User2 in the column ATENCIONXUSUARIO, but we cant filter to in the column "Estado" the word Cerrado.

How can i do that?

[kaushiknsolanki]

Hi,

     Try this.

Count({< ATENCIONXUSUARIO={User1, User2},Estado = {"Cerrado"} >} Estado)

Regards,

Kaushik Solanki