Show total row wise in pivot table

yashcena — Fri, 07 Jul 2017 07:35:11 GMT

(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

Re: Show total row wise in pivot table

sunny_talwar — Fri, 07 Jul 2017 11:25:08 GMT

Try this expression

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

topic Show total row wise in pivot table in QlikView

Show total row wise in pivot table

Re: Show total row wise in pivot table