Qliksense - How to show row wise % in pivot table

[praju179396]

Hello,

I want to show row wise % in pivot table. Each row total % should be 100% .

Italy	100.00%	5.00%	1.00%	5.00%	10.00%	2.50%	5.00%	1.00%	5.00%	10.00%	2.50%	5.00%	1.00%	5.00%	10.00%	2.50%	0.00%	5.00%	1.00%	5.00%	10.00%	2.50%	1.00%	1.00%	2.00%	1.00%	1.00%
Belgium	100.00%	4.61%	1.97%	4.61%	7.89%	2.96%	4.61%	1.97%	4.61%	7.89%	2.96%	4.61%	1.97%	4.61%	7.89%	2.96%	1.32%	4.61%	1.97%	4.61%	7.89%	2.96%	1.97%	1.97%	2.63%	1.97%	1.97%
United Kingdom	100.00%	4.45%	2.36%	4.45%	7.07%	3.14%	4.45%	2.36%	4.45%	7.07%	3.14%	4.45%	2.36%	4.45%	7.07%	3.14%	1.83%	4.45%	2.36%	4.45%	7.07%	3.14%	2.36%	2.36%	2.88%	2.36%	2.36%

[vinieme12]

sum(Sales)/sum(total <ColumnDimension>Sales)

[praju179396 · Accepted solution]

Thanks Vinieme . I have used Drill Down in Column Dimension . 

So there are 5 dimensions. Like Region, Country , Branch, Sales Person.

Any option to enter drill down in my expression.

[praju179396]

Hello Vinieme,

Thanks for the solution. It is working for me. I have taken all the drill down Dimension in it.

[vinieme12]

try 

sum(Sales)/sum(total <$(=GetObjectDimension(2))>Sales)