Count Calculate

[KNRaju105630]

Hi All, 

I have 4 fields - data like below (Value1+Value2+Value3=100)

I have to count my records (It should not be greater than 10 for two values)

Below is my table 

Name, Value1, Value2, Value2
ABC, 50, 25, 25
BCA ,100,,
ZZZ, 80, 10, 10
AAA, 90, 10,
BBB, 50, 50,

My out put should be   (The count should be 3, because here I have no value greater than 10 for all 3 combination values)

Name, Value1, Value2, Value2
BCA ,100,,
ZZZ, 80, 10, 10
AAA, 90, 10

Thanks in Advance!

[Chanty4u]

Try this .

=count({<Value1={">10"}, Value2={">10"}, Value3={">10"}>} DISTINCT Name)