topic Re: % Contribution in pivot table in QlikView https://community.qlik.com/t5/QlikView/Contribution-in-pivot-table/m-p/814752#M534578 <HTML><HEAD></HEAD><BODY><P>Works perfectly. Thanks..</P></BODY></HTML> Wed, 04 Feb 2015 10:24:54 GMT diwakarnahata 2015-02-04T10:24:54Z % Contribution in pivot table https://community.qlik.com/t5/QlikView/Contribution-in-pivot-table/m-p/814750#M534575 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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?</P><P></P><P>Regards,</P><P>Diwakar</P></BODY></HTML> Tue, 03 Feb 2015 11:51:45 GMT https://community.qlik.com/t5/QlikView/Contribution-in-pivot-table/m-p/814750#M534575 diwakarnahata 2015-02-03T11:51:45Z Re: % Contribution in pivot table https://community.qlik.com/t5/QlikView/Contribution-in-pivot-table/m-p/814751#M534576 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use Total in your expression</P><P>for calculating %</P><P></P><P>Your Expression Like</P><P></P><P>yourExpression/Sum(Total&lt;2nd DimensionName&gt;Sales)</P><P></P><P>Regards</P></BODY></HTML> Tue, 03 Feb 2015 11:59:42 GMT https://community.qlik.com/t5/QlikView/Contribution-in-pivot-table/m-p/814751#M534576 PrashantSangle 2015-02-03T11:59:42Z Re: % Contribution in pivot table https://community.qlik.com/t5/QlikView/Contribution-in-pivot-table/m-p/814752#M534578 <HTML><HEAD></HEAD><BODY><P>Works perfectly. Thanks..</P></BODY></HTML> Wed, 04 Feb 2015 10:24:54 GMT https://community.qlik.com/t5/QlikView/Contribution-in-pivot-table/m-p/814752#M534578 diwakarnahata 2015-02-04T10:24:54Z