topic show partial sums in QlikView https://community.qlik.com/t5/QlikView/show-partial-sums/m-p/827106#M291213 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have got some probs with the partial sums.</P><P></P><P>in my pivot i have a few columns.</P><P></P><P>qty | salesprice | costprice/piece | costprice*qty</P><P></P><P>the&nbsp; expression for the costprice * qty is = column(3)*sum(QTYORDERED)</P><P></P><P>Column(3) = FirstSortedValue(COSTPRICE,-MODIFIEDDATETIME_INVENTTABLEMODUL)</P><P></P><P></P><P>in the partial sums the system calculate the sum of qty with a i dont know where this costprice comes from ????</P><P></P><P>can me help someone?</P></BODY></HTML> Mon, 15 Dec 2014 15:15:13 GMT 2014-12-15T15:15:13Z show partial sums https://community.qlik.com/t5/QlikView/show-partial-sums/m-p/827106#M291213 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have got some probs with the partial sums.</P><P></P><P>in my pivot i have a few columns.</P><P></P><P>qty | salesprice | costprice/piece | costprice*qty</P><P></P><P>the&nbsp; expression for the costprice * qty is = column(3)*sum(QTYORDERED)</P><P></P><P>Column(3) = FirstSortedValue(COSTPRICE,-MODIFIEDDATETIME_INVENTTABLEMODUL)</P><P></P><P></P><P>in the partial sums the system calculate the sum of qty with a i dont know where this costprice comes from ????</P><P></P><P>can me help someone?</P></BODY></HTML> Mon, 15 Dec 2014 15:15:13 GMT https://community.qlik.com/t5/QlikView/show-partial-sums/m-p/827106#M291213 2014-12-15T15:15:13Z