topic Pivot Grid Partial Total are wrong !!! in QlikView https://community.qlik.com/t5/QlikView/Pivot-Grid-Partial-Total-are-wrong/m-p/489781#M557992 <HTML><HEAD></HEAD><BODY><P>Hi, <BR />Can someone help me with this?</P><P></P><P>I have almost the same problem. I have an Expression&nbsp; that is the multiplication of two parts (Part A * part B).<BR /> When I make the sum of my own for the two parts, and then multiply both TOTALS it is correct. But it is not the correct total for the pivot grid.</P><P></P><P>This is the Expression</P><P> (Sum(STOCK_AL_CIERRE_AJU)&nbsp; - Sum(VENTA_AJU) + Sum(CAJAS))&nbsp;&nbsp;&nbsp;&nbsp; // PART A</P><P>&nbsp;&nbsp;&nbsp;&nbsp; *&nbsp;&nbsp;&nbsp; </P><P> (sum(NIV)/sum( CAJAS)) // PART B</P><P></P><P></P><P>I only use one Dimension, it is YearMonth.</P></BODY></HTML> Wed, 19 Jun 2013 20:31:43 GMT 2013-06-19T20:31:43Z Pivot Grid Partial Total are wrong !!! https://community.qlik.com/t5/QlikView/Pivot-Grid-Partial-Total-are-wrong/m-p/489781#M557992 <HTML><HEAD></HEAD><BODY><P>Hi, <BR />Can someone help me with this?</P><P></P><P>I have almost the same problem. I have an Expression&nbsp; that is the multiplication of two parts (Part A * part B).<BR /> When I make the sum of my own for the two parts, and then multiply both TOTALS it is correct. But it is not the correct total for the pivot grid.</P><P></P><P>This is the Expression</P><P> (Sum(STOCK_AL_CIERRE_AJU)&nbsp; - Sum(VENTA_AJU) + Sum(CAJAS))&nbsp;&nbsp;&nbsp;&nbsp; // PART A</P><P>&nbsp;&nbsp;&nbsp;&nbsp; *&nbsp;&nbsp;&nbsp; </P><P> (sum(NIV)/sum( CAJAS)) // PART B</P><P></P><P></P><P>I only use one Dimension, it is YearMonth.</P></BODY></HTML> Wed, 19 Jun 2013 20:31:43 GMT https://community.qlik.com/t5/QlikView/Pivot-Grid-Partial-Total-are-wrong/m-p/489781#M557992 2013-06-19T20:31:43Z