topic Re: Subtotal % Problem in QlikView https://community.qlik.com/t5/QlikView/Subtotal-Problem/m-p/566154#M211220 <HTML><HEAD></HEAD><BODY><P>Aha, then you want this:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum(Qt) / Sum(TOTAL&lt;Store&gt; Qt)</SPAN></P></BODY></HTML> Fri, 24 Jan 2014 13:46:00 GMT 2014-01-24T13:46:00Z Subtotal % Problem https://community.qlik.com/t5/QlikView/Subtotal-Problem/m-p/566151#M211217 <HTML><HEAD></HEAD><BODY><P>I want this pivot table but I don't know how to build the last formula, as "sum(Qt) / sum(TOTAL)". How do I do?</P><P></P><TABLE border="1" class="jiveBorder" height="200" style="border: 1px solid rgb(0, 0, 0); width: 788px; height: 189px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Store</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Product</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Qt</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">%</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">X</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">50%</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Z</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">50%</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">Total</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">100%</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">X</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">29%</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">Z</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">71%</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">Total</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">100%</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 24 Jan 2014 12:43:18 GMT https://community.qlik.com/t5/QlikView/Subtotal-Problem/m-p/566151#M211217 2014-01-24T12:43:18Z Re: Subtotal % Problem https://community.qlik.com/t5/QlikView/Subtotal-Problem/m-p/566152#M211218 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Try this:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum(Qt) / Sum(TOTAL Qt)</SPAN></P></BODY></HTML> Fri, 24 Jan 2014 12:51:48 GMT https://community.qlik.com/t5/QlikView/Subtotal-Problem/m-p/566152#M211218 2014-01-24T12:51:48Z Re: Subtotal % Problem https://community.qlik.com/t5/QlikView/Subtotal-Problem/m-p/566153#M211219 <HTML><HEAD></HEAD><BODY><P>Yeh, we already tried it, but the value in percentage appears as TOTAL of&nbsp; sum of stores, for example, in the table, to the first line appears as 18% (2/11) and not 50% (2/4).</P><P></P><P>Any other idea?</P></BODY></HTML> Fri, 24 Jan 2014 13:20:59 GMT https://community.qlik.com/t5/QlikView/Subtotal-Problem/m-p/566153#M211219 2014-01-24T13:20:59Z Re: Subtotal % Problem https://community.qlik.com/t5/QlikView/Subtotal-Problem/m-p/566154#M211220 <HTML><HEAD></HEAD><BODY><P>Aha, then you want this:</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum(Qt) / Sum(TOTAL&lt;Store&gt; Qt)</SPAN></P></BODY></HTML> Fri, 24 Jan 2014 13:46:00 GMT https://community.qlik.com/t5/QlikView/Subtotal-Problem/m-p/566154#M211220 2014-01-24T13:46:00Z