topic Re: Cumulative / running partial sums in QlikView https://community.qlik.com/t5/QlikView/Cumulative-running-partial-sums/m-p/760884#M270708 <HTML><HEAD></HEAD><BODY><P>I have solved it:</P><P></P><P>If(Dimensionality()=1</P><P> ,Aggr(RangeSum(Above(Sum([Amount]),0,RowNo(TOTAL))),Section)</P><P> ,IF(Dimensionality()=0</P><P> ,Sum(Amount)</P><P> ,Sum((Amount))))</P><P></P><P>Needs a bit of tweaking but this basically does the job</P><P></P><P></P></BODY></HTML> Sat, 24 Jan 2015 21:58:00 GMT 2015-01-24T21:58:00Z Cumulative / running partial sums https://community.qlik.com/t5/QlikView/Cumulative-running-partial-sums/m-p/760883#M270707 <HTML><HEAD></HEAD><BODY><P>Does anyone know a way of making partial sums on a pivot table add on the subtotal above it please?</P><P></P><P>I am trying to replicate it using Rangesum (Above(&nbsp; , but I am not having any success with it.</P><P></P><P>Ideally I would like:</P><P></P><P>Section&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Account&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</P><P>Section 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>Section 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 124&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P><STRONG>Subtotal Section 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25</STRONG></P><P>Section&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>Section&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P><STRONG>Subtotal Section 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40</STRONG></P><P></P><P>etc.</P><P></P><P>Thanks,</P><P></P><P>Chris</P></BODY></HTML> Sat, 24 Jan 2015 21:01:57 GMT https://community.qlik.com/t5/QlikView/Cumulative-running-partial-sums/m-p/760883#M270707 2015-01-24T21:01:57Z Re: Cumulative / running partial sums https://community.qlik.com/t5/QlikView/Cumulative-running-partial-sums/m-p/760884#M270708 <HTML><HEAD></HEAD><BODY><P>I have solved it:</P><P></P><P>If(Dimensionality()=1</P><P> ,Aggr(RangeSum(Above(Sum([Amount]),0,RowNo(TOTAL))),Section)</P><P> ,IF(Dimensionality()=0</P><P> ,Sum(Amount)</P><P> ,Sum((Amount))))</P><P></P><P>Needs a bit of tweaking but this basically does the job</P><P></P><P></P></BODY></HTML> Sat, 24 Jan 2015 21:58:00 GMT https://community.qlik.com/t5/QlikView/Cumulative-running-partial-sums/m-p/760884#M270708 2015-01-24T21:58:00Z