topic Re: Help with Pivot table? in QlikView https://community.qlik.com/t5/QlikView/Help-with-Pivot-table/m-p/74056#M12215 <HTML><HEAD></HEAD><BODY><P>use Sum(Net)/Sum(Total &lt;Group&gt; Net) for your % column.</P></BODY></HTML> Thu, 08 Feb 2018 14:48:11 GMT neelamsaroha157 2018-02-08T14:48:11Z Help with Pivot table? https://community.qlik.com/t5/QlikView/Help-with-Pivot-table/m-p/74055#M12214 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I have a pivot table and i m not getting expected results when i&nbsp; use Total function. Can anyone please help me to understand where i went wrong?</P><P></P><P>Please find attached document which explains my problem with example.</P></BODY></HTML> Thu, 08 Feb 2018 14:44:14 GMT https://community.qlik.com/t5/QlikView/Help-with-Pivot-table/m-p/74055#M12214 qlikuser222 2018-02-08T14:44:14Z Re: Help with Pivot table? https://community.qlik.com/t5/QlikView/Help-with-Pivot-table/m-p/74056#M12215 <HTML><HEAD></HEAD><BODY><P>use Sum(Net)/Sum(Total &lt;Group&gt; Net) for your % column.</P></BODY></HTML> Thu, 08 Feb 2018 14:48:11 GMT https://community.qlik.com/t5/QlikView/Help-with-Pivot-table/m-p/74056#M12215 neelamsaroha157 2018-02-08T14:48:11Z Re: Help with Pivot table? https://community.qlik.com/t5/QlikView/Help-with-Pivot-table/m-p/74057#M12216 <HTML><HEAD></HEAD><BODY><P>the sum total net should take into consideration the Group dimension</P><P>so your expression should be sum(Net)/Sum(Total&lt;Group&gt;Net)<IMG alt="community.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192854_community.PNG" style="height: 112px; width: 620px;" /></P></BODY></HTML> Thu, 08 Feb 2018 14:50:32 GMT https://community.qlik.com/t5/QlikView/Help-with-Pivot-table/m-p/74057#M12216 ali_hijazi 2018-02-08T14:50:32Z