topic Re: prob with sum in QlikView https://community.qlik.com/t5/QlikView/prob-with-sum/m-p/740164#M264407 <HTML><HEAD></HEAD><BODY><P>Can you post sample app and expected output</P></BODY></HTML> Tue, 06 Jan 2015 12:52:50 GMT anbu1984 2015-01-06T12:52:50Z prob with sum https://community.qlik.com/t5/QlikView/prob-with-sum/m-p/740163#M264406 <HTML><HEAD></HEAD><BODY><P>Hi and a happy new year!</P><P>i have got a problem with the sum in a pivot table.</P><P></P><P>my dimensions are</P><P>attribute|SalesID|ItemID</P><P></P><P>my columns are</P><P></P><P>1. sum(QTYORDERED)</P><P>2. sum(lineamount)</P><P>3. FirstSortedValue(COSTPRICE,MODIFIEDDATETIME_INVENTTABLEMODUL)*sum(QTYORDERED)</P><P>4. sum(lineamount)-FirstSortedValue(COSTPRICE,-MODIFIEDDATETIME_INVENTTABLEMODUL)*sum(QTYORDERED)</P><P></P><P>my problem is in the 3. and 4. column</P><P>i need the sum of them only shown for the first dimension (attribut) i have 10 attributes so i want to see the sum of these 10 rows but it doesnt work only when i show all rows for itemID</P><P></P><P>has anybody an idea?</P></BODY></HTML> Tue, 06 Jan 2015 10:45:40 GMT https://community.qlik.com/t5/QlikView/prob-with-sum/m-p/740163#M264406 2015-01-06T10:45:40Z Re: prob with sum https://community.qlik.com/t5/QlikView/prob-with-sum/m-p/740164#M264407 <HTML><HEAD></HEAD><BODY><P>Can you post sample app and expected output</P></BODY></HTML> Tue, 06 Jan 2015 12:52:50 GMT https://community.qlik.com/t5/QlikView/prob-with-sum/m-p/740164#M264407 anbu1984 2015-01-06T12:52:50Z