Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table which shows the count of test cases and I'm showing it horizontally.
(image from an excel export)
I want to show the percentage row wise. Instead, it is calculating the percentage column-wise.
For example, in CR4701 US130543 there are 12 test cases and all of them are in Pass state. So the pass percentage should be 100%. Instead, it is calculating the percentage by taking all the 'Pass' test cases i.e. 195 [(12/195)*100]. It should calculate only for that particular CR.
Is there any way to do that? I hope I have made my requirement clear.
Expression for count:
count(TestCaseID)
Expression for Percentage:
count(TestCaseID)/count(total(TestCaseID))
(I think for the % expression, the denominator is wrong.)
Thanks,
YASH
Hi,
Try this.
count(TestCaseID)/count(total<TestCaseCRs>(TestCaseID))
Regards,
Kaushik Solanki
Hi Kaushik....this expression did not work.
May be these:
Count(TestCaseID)/Count(total <DIM1> TestCaseID)
or
Count(TestCaseID)/Count(total <DIM1, DIM2> TestCaseID)
or
if(dimensionality()=0, Count(TestCaseID)/Count(total <DimA> TestCaseID), sum(TestCaseID)) // (Think so)
Would you be able to share the sample file?
I'm not able to find the option to attach .qvw. Drag and drop also didnt work
Hi Bala..i tried this expression but it didnt work. Kaushik had already asked me to try it.
thanks..
Hi,
See the attached app.
Regards,
Kaushik Solanki
Look here