Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
diwakarnahata
Creator
Creator

% Contribution in pivot table

Hi,

I have a pivot table with 2 dimensions and 1 expression. Here in the expression i want to show the % contribution of the second dimension. I tried using partial sums on second dimension, but couldn't put that in the denominator of the expression to show its contribution. Is there any way we can implement this?

Regards,

Diwakar

1 Solution

Accepted Solutions
PrashantSangle

Hi,

use Total in your expression

for calculating %

Your Expression Like

yourExpression/Sum(Total<2nd DimensionName>Sales)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

2 Replies
PrashantSangle

Hi,

use Total in your expression

for calculating %

Your Expression Like

yourExpression/Sum(Total<2nd DimensionName>Sales)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
diwakarnahata
Creator
Creator
Author

Works perfectly. Thanks..