Column A: Categorey
Column B : Test Cases id
Column C: Status
Column D: pass
Column E: Fail
I want to search for Account cateogrey from Column B and add all pass for this categorey and put the value in Pass column of D similalry Fail and No run
@ SirJB7,
Iam looking for each categorey how many pass fail and no run?
Example:
Cloumn B - Cateogrey
Iwant how many passed , failed , Not run for this particular categorey and similalry other categoreis...
@ Debraj,
Thanks for response, i might posted question wrongly here is what iam looking for?
I want find the category = Account (COlumn B) and want to see how many are total failed, passed and norun in each respcted columns of pass, fail & No run
For example: Categorey- Account - 2 pass, 2...
Column A: Categorey
Column B : Test Cases id
Column C: Status
Column D: pass
Column E: Fail
I want to search for Account cateogrey from Column A and add all pass for this categorey and put the value in Pass column of D similalry Fail and No run
hoe this is clear
Category/User TestCAse...
Adding the values of columns if the Category in one cloumn has value of pass, fail and No run in other column, then want sum of Pass, fail and No Run in seprate columns
Category Test Cases Pass/Fail
Account TC001 Pass
Account TC002 Fail
F01
F03
.
...