Show total row wise in pivot table

[yashcena]

(I had posted the same question yesterday and got a couple of replies asking to attach a sample file. I was not able to do it in the original post so posting this question again.)

I have a pivot table which shows the count of test cases and I'm showing it horizontally.

I want to show the percentage row wise. Instead, it is calculating the percentage column-wise.

Is there any way to do that? I hope I have made my requirement clear. I want to show both count and percentage.

Expression for count:

count(TestCaseID)

Expression for Percentage:

count(TestCaseID)/count(total(TestCaseID))

Thanks,

YASH

[sunny_talwar]

Try this expression

Count(TestCaseID)/Count(TOTAL <CRName, StoryProjectName, TestCaseID, TestCaseName> TestCaseID)