topic Re: special sum in pivot table in QlikView

topic Re: special sum in pivot table in QlikView https://community.qlik.com/t5/QlikView/special-sum-in-pivot-table/m-p/336519#M124120 <HTML><HEAD></HEAD><BODY><P>Try something like rangesum(sum1,above(sum1))</P><P></P><P>Or use a straight table and use the function accumulate.</P></BODY></HTML> Fri, 03 Aug 2012 12:42:59 GMT 2012-08-03T12:42:59Z special sum in pivot table https://community.qlik.com/t5/QlikView/special-sum-in-pivot-table/m-p/336518#M124119 <HTML><HEAD></HEAD><BODY><P>I want pivot table to show result like this</P><P></P><P></P><P>sum1   sum2</P><P>5         5</P><P>6         11</P><P>7          18</P><P></P><P></P><P>Sum2 always shows the total of all values of sum1</P><P></P><P></P><P></P><P>how it is possible?</P><P></P><P></P><P>thanks</P><P>Lavi</P></BODY></HTML> Fri, 03 Aug 2012 10:20:39 GMT https://community.qlik.com/t5/QlikView/special-sum-in-pivot-table/m-p/336518#M124119 2012-08-03T10:20:39Z Re: special sum in pivot table https://community.qlik.com/t5/QlikView/special-sum-in-pivot-table/m-p/336519#M124120 <HTML><HEAD></HEAD><BODY><P>Try something like rangesum(sum1,above(sum1))</P><P></P><P>Or use a straight table and use the function accumulate.</P></BODY></HTML> Fri, 03 Aug 2012 12:42:59 GMT https://community.qlik.com/t5/QlikView/special-sum-in-pivot-table/m-p/336519#M124120 2012-08-03T12:42:59Z