% vs total in pivot table only on row dimension

chriscools — Thu, 10 Mar 2022 15:39:12 GMT

Hello,

i have a pivot table in qlikview with an expression that gives met the % vs total for sales :

sum({<Year={2021}>}qty_unit_delivered*price_net_computed)/sum(total{<Year={2021}>}qty_unit_delivered*price_net_computed)

it works correct as long as for example i have only dimension on the left side.

If i put the agent on the left side then it gives met the % from total for each agent.

But now i want a different visualisation where i want the agent on the left side and sales channel on top.

And i would like to compare the % for each segment between the agents.

So i need that the calculated % on the row of the agent each time is 100 %.

And with the expression above it takes the whole tabel across al the agents and channels as 100 %:

I'm not sure on how to adapt the expression for this.

Someone who can help me with it?

thanx

Chris

topic % vs total in pivot table only on row dimension in App Development