topic Re: Partial sums in pivot table with several dimensions in QlikView https://community.qlik.com/t5/QlikView/Partial-sums-in-pivot-table-with-several-dimensions/m-p/7692#M512508 <HTML><HEAD></HEAD><BODY><P>Pero eso hace que me salga la suma total de todos los meses abajo. Yo necesito que me saque un desglose de la suma de toda la comida buena y toda la comida mala (En la segunda tabla, CR =&nbsp; Bad y HR = Good)</P></BODY></HTML> Fri, 09 Feb 2018 08:03:53 GMT juanm_olondo 2018-02-09T08:03:53Z Partial sums in pivot table with several dimensions https://community.qlik.com/t5/QlikView/Partial-sums-in-pivot-table-with-several-dimensions/m-p/7690#M512506 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a Pivot Table with 3 dimensions and 1 expression, as you can see in the picture below:</P><P><IMG alt="EjemploNO.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191501_EjemploNO.png" style="height: 198px; width: 620px;" /></P><P>I have activated the 'Show partial sums' option for both the food and the quality, but I don´t get the total quantities in good state and in bad state. I would like it to appear this way:</P><P><IMG alt="EjemploSI.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/191502_EjemploSI.png" style="height: 180px; width: 620px;" /></P><P>Does anyone have any ideas of how I can get this? Thanks a lot!</P></BODY></HTML> Fri, 26 Jan 2018 08:26:02 GMT https://community.qlik.com/t5/QlikView/Partial-sums-in-pivot-table-with-several-dimensions/m-p/7690#M512506 juanm_olondo 2018-01-26T08:26:02Z Re: Partial sums in pivot table with several dimensions https://community.qlik.com/t5/QlikView/Partial-sums-in-pivot-table-with-several-dimensions/m-p/7691#M512507 <HTML><HEAD></HEAD><BODY><P>Activa Show partial sums para la dimension que tiene el encabezado "Mes"</P></BODY></HTML> Tue, 06 Feb 2018 17:43:42 GMT https://community.qlik.com/t5/QlikView/Partial-sums-in-pivot-table-with-several-dimensions/m-p/7691#M512507 alexandermorale 2018-02-06T17:43:42Z Re: Partial sums in pivot table with several dimensions https://community.qlik.com/t5/QlikView/Partial-sums-in-pivot-table-with-several-dimensions/m-p/7692#M512508 <HTML><HEAD></HEAD><BODY><P>Pero eso hace que me salga la suma total de todos los meses abajo. Yo necesito que me saque un desglose de la suma de toda la comida buena y toda la comida mala (En la segunda tabla, CR =&nbsp; Bad y HR = Good)</P></BODY></HTML> Fri, 09 Feb 2018 08:03:53 GMT https://community.qlik.com/t5/QlikView/Partial-sums-in-pivot-table-with-several-dimensions/m-p/7692#M512508 juanm_olondo 2018-02-09T08:03:53Z