topic Re: Strange sum in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Strange-sum-in-Pivot-table/m-p/1390374#M816543 <HTML><HEAD></HEAD><BODY><P>SEGUE ANEXO</P></BODY></HTML> Mon, 11 Sep 2017 12:04:23 GMT marcelviegas 2017-09-11T12:04:23Z Strange sum in Pivot table https://community.qlik.com/t5/QlikView/Strange-sum-in-Pivot-table/m-p/1390371#M816540 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P></P><P>I need to do a strange sum on a pivot table,</P><P></P><P>this is the result i have:</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 626px;"><TBODY><TR><TD class="xl63" height="17" width="98">SALESMAN</TD><TD class="xl63" style="border-left: none;" width="98">PRODUCT</TD><TD class="xl64" style="border-left: none;" width="98">KPI</TD><TD class="xl65" width="332">KPI</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">X</TD><TD class="xl65" style="border-top: none; border-left: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">SALES</TD><TD class="xl65" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">X</TD><TD class="xl65" style="border-top: none; border-left: none;">2</TD><TD class="xl65" style="border-top: none; border-left: none;">SALES</TD><TD class="xl65" style="border-top: none; border-left: none;">7</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Y</TD><TD class="xl65" style="border-top: none; border-left: none;">3</TD><TD class="xl65" style="border-top: none; border-left: none;">SALES</TD><TD class="xl65" style="border-top: none; border-left: none;">9</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">-</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD><TD class="xl65" style="border-top: none; border-left: none;">MARGIN</TD><TD class="xl65" style="border-top: none; border-left: none;">54</TD></TR></TBODY></TABLE><P></P><P>and this is the result i <STRONG>want:</STRONG></P><P><STRONG><BR /></STRONG></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 626px;"><TBODY><TR><TD class="xl65" height="17" width="98">SALESMAN</TD><TD class="xl65" style="border-left: none;" width="98">PRODUCT</TD><TD class="xl66" style="border-left: none;" width="98">KPI</TD><TD class="xl67" width="332">KPI</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">X</TD><TD class="xl67" style="border-top: none; border-left: none;">1</TD><TD class="xl67" style="border-top: none; border-left: none;">SALES</TD><TD class="xl67" style="border-top: none; border-left: none;">5</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">X</TD><TD class="xl67" style="border-top: none; border-left: none;">1</TD><TD class="xl67" style="border-top: none; border-left: none;">MARGIN</TD><TD class="xl67" style="border-top: none; border-left: none;">54</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">X</TD><TD class="xl67" style="border-top: none; border-left: none;">2</TD><TD class="xl67" style="border-top: none; border-left: none;">SALES</TD><TD class="xl67" style="border-top: none; border-left: none;">7</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">X</TD><TD class="xl67" style="border-top: none; border-left: none;">1</TD><TD class="xl67" style="border-top: none; border-left: none;">MARGIN</TD><TD class="xl67" style="border-top: none; border-left: none;">54</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">Y</TD><TD class="xl67" style="border-top: none; border-left: none;">3</TD><TD class="xl67" style="border-top: none; border-left: none;">SALES</TD><TD class="xl67" style="border-top: none; border-left: none;">9</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">X</TD><TD class="xl67" style="border-top: none; border-left: none;">1</TD><TD class="xl67" style="border-top: none; border-left: none;">MARGIN</TD><TD class="xl67" style="border-top: none; border-left: none;">54</TD></TR></TBODY></TABLE><P></P><P>i attached the file with the example.</P><P></P><P>thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Strange-sum-in-Pivot-table/m-p/1390371#M816540 Anonymous 2020-11-25T16:16:04Z Re: Strange sum in Pivot table https://community.qlik.com/t5/QlikView/Strange-sum-in-Pivot-table/m-p/1390372#M816541 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: arial, sans-serif; font-size: 29px;">all equal kpis have the same margin?</SPAN></P></BODY></HTML> Mon, 11 Sep 2017 11:44:24 GMT https://community.qlik.com/t5/QlikView/Strange-sum-in-Pivot-table/m-p/1390372#M816541 marcelviegas 2017-09-11T11:44:24Z Re: Strange sum in Pivot table https://community.qlik.com/t5/QlikView/Strange-sum-in-Pivot-table/m-p/1390373#M816542 <HTML><HEAD></HEAD><BODY><P>Something like this</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176109_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 11 Sep 2017 11:48:22 GMT https://community.qlik.com/t5/QlikView/Strange-sum-in-Pivot-table/m-p/1390373#M816542 sunny_talwar 2017-09-11T11:48:22Z Re: Strange sum in Pivot table https://community.qlik.com/t5/QlikView/Strange-sum-in-Pivot-table/m-p/1390374#M816543 <HTML><HEAD></HEAD><BODY><P>SEGUE ANEXO</P></BODY></HTML> Mon, 11 Sep 2017 12:04:23 GMT https://community.qlik.com/t5/QlikView/Strange-sum-in-Pivot-table/m-p/1390374#M816543 marcelviegas 2017-09-11T12:04:23Z