topic Re: Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/911002#M316286 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SUM(NET_PROVISION) / SUM(TOTAL &lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PAID_MONTH&gt; </SPAN>NET_PROVISION)</SPAN></P></BODY></HTML> Wed, 22 Jul 2015 22:31:10 GMT maxgro 2015-07-22T22:31:10Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/911001#M316285 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have following Pivot Table where I can't calculate the % as I want</P><P></P><TABLE><TBODY><TR><TD>PAID_MONTH</TD><TD>PROV_MONTH</TD><TD>PROVISION</TD><TD> Pivot %</TD><TD>Correct %</TD></TR><TR><TD>2015-01</TD><TD>&gt;5 MONTHS</TD><TD>42,561,994</TD><TD>8%</TD><TD>17%</TD></TR><TR><TD>2015-01</TD><TD>2014-09</TD><TD>7,935,724</TD><TD>2%</TD><TD>3%</TD></TR><TR><TD>2015-01</TD><TD>2014-10</TD><TD>14,965,739</TD><TD>3%</TD><TD>6%</TD></TR><TR><TD>2015-01</TD><TD>2014-11</TD><TD>29,029,279</TD><TD>6%</TD><TD>12%</TD></TR><TR><TD>2015-01</TD><TD>2014-12</TD><TD>79,093,410</TD><TD>15%</TD><TD>32%</TD></TR><TR><TD>2015-01</TD><TD>2015-01</TD><TD>75,031,821</TD><TD>14%</TD><TD>30%</TD></TR><TR><TD><STRONG>2015-01</STRONG></TD><TD><STRONG>Total</STRONG></TD><TD><STRONG>248,617,969</STRONG></TD><TD><STRONG>48%</STRONG></TD><TD><STRONG>100%</STRONG></TD></TR><TR><TD>2015-02</TD><TD>&gt;5 MONTHS</TD><TD>19,259,568</TD><TD>4%</TD><TD>7%</TD></TR><TR><TD>2015-02</TD><TD>2014-10</TD><TD>19,358,724</TD><TD>4%</TD><TD>7%</TD></TR><TR><TD>2015-02</TD><TD>2014-11</TD><TD>12,433,036</TD><TD>2%</TD><TD>5%</TD></TR><TR><TD>2015-02</TD><TD>2014-12</TD><TD>52,992,433</TD><TD>10%</TD><TD>19%</TD></TR><TR><TD>2015-02</TD><TD>2015-01</TD><TD>51,543,303</TD><TD>10%</TD><TD>19%</TD></TR><TR><TD>2015-02</TD><TD>2015-02</TD><TD>117,331,247</TD><TD>22%</TD><TD>43%</TD></TR><TR><TD><STRONG>2015-02</STRONG></TD><TD><STRONG>Total</STRONG></TD><TD><STRONG>272,918,310</STRONG></TD><TD><STRONG>52%</STRONG></TD><TD><STRONG>100%</STRONG></TD></TR><TR><TD><STRONG>Total</STRONG></TD><TD></TD><TD>521,536,278</TD><TD>100%</TD><TD></TD></TR></TBODY></TABLE><P></P><P>Expression I have written is follows</P><P></P><P>SUM(NET_PROVISION)/SUM(TOTAL(NET_PROVISION))</P><P>The Pivot % is tne one I get from the Pivot Tbale where as I want % to be calculated as given in last column&nbsp; (Correct %). Pls help me</P></BODY></HTML> Wed, 22 Jul 2015 22:25:52 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/911001#M316285 upaliwije 2015-07-22T22:25:52Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/911002#M316286 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SUM(NET_PROVISION) / SUM(TOTAL &lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PAID_MONTH&gt; </SPAN>NET_PROVISION)</SPAN></P></BODY></HTML> Wed, 22 Jul 2015 22:31:10 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/911002#M316286 maxgro 2015-07-22T22:31:10Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/911003#M316287 <HTML><HEAD></HEAD><BODY><P>Thanks a lot</P></BODY></HTML> Wed, 22 Jul 2015 22:37:34 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/911003#M316287 upaliwije 2015-07-22T22:37:34Z