How to get the count of the data with some specified requirement

[Gaddam]

Hello Everyone,

I have a problem in finding out the count of the specific testsuite executed/Tested for each build. As per the below data ,How can i get the values specified in the column No:of Tested

Thanks in advance for the help

[serpiva64]

Sorry, i can't understand what is your desired result from your exemple. Can you explain it better?

[Gaddam]

Thank you for responding.

For Each build, we have 3 sets of Testsuites, they are tested based on requirement.like
1.Testsuite is AAA is Tested , BBB is Tested, and CCC is not Tested
2.Testsuite is AAA is Tested , BBB is not Tested, and CCC is Tested and so on..
When they are tested the test reults are stored in the Tested column as 1, 0, 2, 3.. I have to calclate the count of each test suit executed for that Buildnumber.
For Build number 111,
Test suite AAA executed 3 times,the result in No:of Tested to be "3" (3 , i.e its passed 2 times and failed 1 time)
Test suite BBB executed 3 times,the result in No:of Tested to be "1"(1, i.e failed 1 time, 2 and 3 are considered as not valid results)
*Only Passed and failed are considered as valid results
Test suite CCC executed 3 times,the result in No:of Tested to be "3"(3,i.e Passed 3 times)