topic Table pivot- %formula in QlikView https://community.qlik.com/t5/QlikView/Table-pivot-formula/m-p/807015#M284884 <HTML><HEAD></HEAD><BODY><P>Hello, First at all, sorry about my english.</P><P></P><P>I have this pivot table</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 240px;"><TBODY><TR><TD class="xl63" height="20" width="80">zona</TD><TD class="xl63" style="border-left: none;" width="80">vendedor</TD><TD class="xl63" style="border-left: none;" width="80">valor</TD></TR><TR><TD class="xl64" height="40" rowspan="2" style="border-top: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">a</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">b</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD></TR><TR><TD class="xl64" height="60" rowspan="3" style="border-top: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">h</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">g</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">150</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">d</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">250</TD></TR></TBODY></TABLE><P></P><P>I need a formula to do this:</P><P></P><P>% por zona</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>25%</STRONG></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>75%</STRONG></P><P></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>11.1%</STRONG></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>33.33%</STRONG></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG> 55.55%</STRONG></P><P></P><P>Anybody can help me with this please?</P></BODY></HTML> Fri, 27 Mar 2015 13:47:00 GMT 2015-03-27T13:47:00Z Table pivot- %formula https://community.qlik.com/t5/QlikView/Table-pivot-formula/m-p/807015#M284884 <HTML><HEAD></HEAD><BODY><P>Hello, First at all, sorry about my english.</P><P></P><P>I have this pivot table</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 240px;"><TBODY><TR><TD class="xl63" height="20" width="80">zona</TD><TD class="xl63" style="border-left: none;" width="80">vendedor</TD><TD class="xl63" style="border-left: none;" width="80">valor</TD></TR><TR><TD class="xl64" height="40" rowspan="2" style="border-top: none;">1</TD><TD class="xl63" style="border-top: none; border-left: none;">a</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">b</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD></TR><TR><TD class="xl64" height="60" rowspan="3" style="border-top: none;">2</TD><TD class="xl63" style="border-top: none; border-left: none;">h</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">g</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">150</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">d</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">250</TD></TR></TBODY></TABLE><P></P><P>I need a formula to do this:</P><P></P><P>% por zona</P><P></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>25%</STRONG></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>75%</STRONG></P><P></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>11.1%</STRONG></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>33.33%</STRONG></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG> 55.55%</STRONG></P><P></P><P>Anybody can help me with this please?</P></BODY></HTML> Fri, 27 Mar 2015 13:47:00 GMT https://community.qlik.com/t5/QlikView/Table-pivot-formula/m-p/807015#M284884 2015-03-27T13:47:00Z Re: Table pivot- %formula https://community.qlik.com/t5/QlikView/Table-pivot-formula/m-p/807016#M284885 <HTML><HEAD></HEAD><BODY><P>No worries!</P><P></P><P>Sum(valor)/Sum(Total &lt;zona&gt; valor) - then format this to show %.</P></BODY></HTML> Fri, 27 Mar 2015 13:48:41 GMT https://community.qlik.com/t5/QlikView/Table-pivot-formula/m-p/807016#M284885 morganaaron 2015-03-27T13:48:41Z Re: Table pivot- %formula https://community.qlik.com/t5/QlikView/Table-pivot-formula/m-p/807017#M284886 <HTML><HEAD></HEAD><BODY><P>Ty !</P></BODY></HTML> Fri, 27 Mar 2015 13:54:47 GMT https://community.qlik.com/t5/QlikView/Table-pivot-formula/m-p/807017#M284886 2015-03-27T13:54:47Z Re: Table pivot- %formula https://community.qlik.com/t5/QlikView/Table-pivot-formula/m-p/807018#M284887 <HTML><HEAD></HEAD><BODY><P>SUM(valor) / SUM(Total &lt;zona&gt; valor) </P><P>or</P><P>SUM(valor) / SUM(All &lt;zona&gt; valor) </P><P>will give you the desired result..</P><P>If you want % across the all lines, use as below</P><P><SPAN style="font-size: 13.3333330154419px;">SUM(valor) / SUM(Total valor)</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">or<BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">SUM(valor) / SUM(All valor)</SPAN></P></BODY></HTML> Fri, 27 Mar 2015 13:57:09 GMT https://community.qlik.com/t5/QlikView/Table-pivot-formula/m-p/807018#M284887 MK_QSL 2015-03-27T13:57:09Z