topic HELP WITH PIVOT - TOTALS AND DIMENSIONALITY in QlikView https://community.qlik.com/t5/QlikView/HELP-WITH-PIVOT-TOTALS-AND-DIMENSIONALITY/m-p/282342#M104965 <HTML><HEAD></HEAD><BODY><P> HI,</P><P>&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp; Try this.</P><P></P><P> <SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">&nbsp;&nbsp;&nbsp;&nbsp; count( distinct idRecibo) / count(distinct&nbsp; total&lt;</SPAN><STRONG style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">R.Salesman</STRONG><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">&gt;&nbsp; idRecibo)</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">Regards,</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">Kaushik Solanki</SPAN></P></BODY></HTML> Sat, 29 Oct 2011 05:52:53 GMT kaushiknsolanki 2011-10-29T05:52:53Z HELP WITH PIVOT - TOTALS AND DIMENSIONALITY https://community.qlik.com/t5/QlikView/HELP-WITH-PIVOT-TOTALS-AND-DIMENSIONALITY/m-p/282341#M104964 <HTML><HEAD></HEAD><BODY><P>I needhelp&nbsp; with totals in a pivot table. Iwant to obtain the data of column number 3, but I don’t know how to do it.</P><P>I need tosee the numbers of bills of each salesman classified in distinct groups. </P><P>Any suggestion?THANKS!!!</P><P></P><TABLE align="left" border="0" cellpadding="0" cellspacing="0" height="804" style="margin-left: 4.8pt; margin-right: 4.8pt; padding: 0pt 3.5pt; width: 871px;"><TBODY><TR><TD nowrap="nowrap" style="background-color: #ebebeb; border: 1pt solid gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"></TD><TD nowrap="nowrap" style="background-color: #ebebeb; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="114"></TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="33"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">1</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P style="margin-bottom: 0.0001pt;"><SPAN lang="EN-US" style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">2</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">3</SPAN></P>&nbsp; </TD><TD colspan="2" style="border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color gainsboro;" width="113"></TD></TR><TR><TD nowrap="nowrap" style="background-color: #ebebeb; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 9pt; font-family: 'Arial','sans-serif';">R.Salesman</STRONG></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: #ebebeb; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><STRONG style="color: #333333; font-size: 9pt; font-family: 'Arial','sans-serif';">R.GrupoVtoCobro</STRONG></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">count(distinct&nbsp; idRecibo)</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P style="margin-bottom: 0.0001pt;"><SPAN lang="EN-US" style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">count( distinct idRecibo) / count(distinct&nbsp; total&nbsp; idRecibo)</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">????</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">Salesman1</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">0 Antes del Vto</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">80</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">0,38%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">2,95%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">Salesman1</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">01 a 15 días</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">453</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">2,17%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">16,72%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">Salesman1</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">16 a 30 días</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">273</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">1,31%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">10,08%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">Salesman1</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">31 a 45 días</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">557</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">2,67%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">20,56%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">Salesman1</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">46 a 60 días</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">501</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">2,40%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">18,49%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">Salesman1</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">61 días o mas</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">845</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">4,06%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">31,19%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">Salesman1</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: whitesmoke; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><STRONG style="color: black; font-size: 9pt; font-family: 'Arial','sans-serif';">Total</STRONG></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: whitesmoke; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><STRONG style="color: black; font-size: 9pt; font-family: 'Arial','sans-serif';">2709</STRONG></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: whitesmoke; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><STRONG style="color: black; font-size: 9pt; font-family: 'Arial','sans-serif';">13,00%</STRONG></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: whitesmoke; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><STRONG style="color: black; font-size: 9pt; font-family: 'Arial','sans-serif';">100,00%</STRONG></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">salesman2</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">0 Antes del Vto</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">27</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">0,13%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">1,14%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">salesman2</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">01 a 15 días</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">293</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">1,41%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">12,36%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">salesman2</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">16 a 30 días</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">365</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">1,75%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">15,40%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">salesman2</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">31 a 45 días</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">420</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">2,02%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">17,72%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">salesman2</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">46 a 60 días</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">350</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">1,68%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">14,77%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">salesman2</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">61 días o mas</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">915</SPAN></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">4,39%</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">38,61%</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color gainsboro gainsboro; padding: 0pt 3.5pt;" valign="bottom" width="99"> <P style="margin-bottom: 0.0001pt;"><SPAN style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 9pt;">salesman2</SPAN></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: whitesmoke; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="123"> <P style="margin-bottom: 0.0001pt;"><STRONG style="color: black; font-size: 9pt; font-family: 'Arial','sans-serif';">Total</STRONG></P>&nbsp; </TD><TD colspan="2" nowrap="nowrap" style="background-color: whitesmoke; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="137"> <P align="right" style="margin-bottom: 0.0001pt;"><STRONG style="color: black; font-size: 9pt; font-family: 'Arial','sans-serif';">2370</STRONG></P>&nbsp; </TD><TD colspan="3" nowrap="nowrap" style="background-color: whitesmoke; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="166"> <P align="right" style="margin-bottom: 0.0001pt;"><STRONG style="color: black; font-size: 9pt; font-family: 'Arial','sans-serif';">11,38%</STRONG></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: whitesmoke; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color gainsboro gainsboro -moz-use-text-color; padding: 0pt 3.5pt;" valign="bottom" width="76"> <P align="right" style="margin-bottom: 0.0001pt;"><STRONG style="color: black; font-size: 9pt; font-family: 'Arial','sans-serif';">100,00%</STRONG></P>&nbsp; </TD></TR><TR><TD style="border: medium none;" width="99"></TD><TD style="border: medium none;" width="114"></TD><TD style="border: medium none;" width="9"></TD><TD style="border: medium none;" width="24"></TD><TD style="border: medium none;" width="113"></TD><TD style="border: medium none;" width="52"></TD></TR></TBODY></TABLE></BODY></HTML> Fri, 28 Oct 2011 20:14:12 GMT https://community.qlik.com/t5/QlikView/HELP-WITH-PIVOT-TOTALS-AND-DIMENSIONALITY/m-p/282341#M104964 2011-10-28T20:14:12Z HELP WITH PIVOT - TOTALS AND DIMENSIONALITY https://community.qlik.com/t5/QlikView/HELP-WITH-PIVOT-TOTALS-AND-DIMENSIONALITY/m-p/282342#M104965 <HTML><HEAD></HEAD><BODY><P> HI,</P><P>&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp; Try this.</P><P></P><P> <SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">&nbsp;&nbsp;&nbsp;&nbsp; count( distinct idRecibo) / count(distinct&nbsp; total&lt;</SPAN><STRONG style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">R.Salesman</STRONG><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">&gt;&nbsp; idRecibo)</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;"> </SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">Regards,</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial', 'sans-serif'; color: #333333; font-size: 9pt;">Kaushik Solanki</SPAN></P></BODY></HTML> Sat, 29 Oct 2011 05:52:53 GMT https://community.qlik.com/t5/QlikView/HELP-WITH-PIVOT-TOTALS-AND-DIMENSIONALITY/m-p/282342#M104965 kaushiknsolanki 2011-10-29T05:52:53Z