https://community.qlik.com/t5/QlikView/Row-wise-percentage-in-pivot-table/m-p/1783235#M1209736 <P>Hi.</P><P>Try:</P><LI-CODE lang="markup">(sum(pm.TOTAL_BILL_AMOUNT))/(sum(TOTAL&lt;BranchName=&gt; pm.TOTAL_BILL_AMOUNT))*100</LI-CODE><P>&nbsp;</P><P>Note that there is = sign after BranchName.&nbsp;</P> Tue, 16 Feb 2021 21:30:13 GMT mfchmielowski 2021-02-16T21:30:13Z https://community.qlik.com/t5/QlikView/Row-wise-percentage-in-pivot-table/m-p/1782718#M1209695 <P>Hi,</P><P>I want to row wise percentage in pivot table. But I am not getting the desired output.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sunitha_chellaiah_0-1613391628812.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/49071iFC39520E8618852D/image-size/medium?v=v2&amp;px=400" role="button" title="sunitha_chellaiah_0-1613391628812.png" alt="sunitha_chellaiah_0-1613391628812.png" /></span></P><P>Percentage to be shown against each branch. But here it is showing 100.0.</P><P>I have used below mentioned expression.</P><P>(sum(pm.TOTAL_BILL_AMOUNT))/(sum(TOTAL&lt;BranchName&gt; pm.TOTAL_BILL_AMOUNT))*100</P><P>Please give me a solution.</P><P>Thanks.</P> Mon, 15 Feb 2021 12:23:04 GMT https://community.qlik.com/t5/QlikView/Row-wise-percentage-in-pivot-table/m-p/1782718#M1209695 sunitha_chellaiah 2021-02-15T12:23:04Z https://community.qlik.com/t5/QlikView/Row-wise-percentage-in-pivot-table/m-p/1783235#M1209736 <P>Hi.</P><P>Try:</P><LI-CODE lang="markup">(sum(pm.TOTAL_BILL_AMOUNT))/(sum(TOTAL&lt;BranchName=&gt; pm.TOTAL_BILL_AMOUNT))*100</LI-CODE><P>&nbsp;</P><P>Note that there is = sign after BranchName.&nbsp;</P> Tue, 16 Feb 2021 21:30:13 GMT https://community.qlik.com/t5/QlikView/Row-wise-percentage-in-pivot-table/m-p/1783235#M1209736 mfchmielowski 2021-02-16T21:30:13Z