Show total row wise in pivot table

[yashcena]

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

[balabhaskarqlik]

Did you resolved the issue, post the solution.