topic Re: Rangesum problem in pivot Table in QlikView https://community.qlik.com/t5/QlikView/Rangesum-problem-in-pivot-Table/m-p/900661#M313394 <HTML><HEAD></HEAD><BODY><P>RangeSum(Above(TOTAL count(ID_Weld2),0,RowNo(TOTAL)))</P></BODY></HTML> Tue, 07 Jul 2015 15:12:51 GMT MK_QSL 2015-07-07T15:12:51Z Rangesum problem in pivot Table https://community.qlik.com/t5/QlikView/Rangesum-problem-in-pivot-Table/m-p/900659#M313392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>first of all any thnaks for your atttention.</P><P>please can you help me to understand why expression "cumulative" and "above" in the pivot that i attach doesn't works?</P><P>when dimension Period Change the rangesum and above function restart to 0....</P><P>many thanks and best regards</P></BODY></HTML> Tue, 07 Jul 2015 14:51:37 GMT https://community.qlik.com/t5/QlikView/Rangesum-problem-in-pivot-Table/m-p/900659#M313392 2015-07-07T14:51:37Z Re: Rangesum problem in pivot Table https://community.qlik.com/t5/QlikView/Rangesum-problem-in-pivot-Table/m-p/900660#M313393 <HTML><HEAD></HEAD><BODY><P>That's because the Period Change indicate a new column segment. I think you want the TOTAL qualifier here:</P><P></P><P>=rangesum(count(ID_Weld2),Above(<STRONG>TOTAL</STRONG> count(ID_Weld2),1,rowno(<STRONG>TOTAL</STRONG>)))</P></BODY></HTML> Tue, 07 Jul 2015 15:05:16 GMT https://community.qlik.com/t5/QlikView/Rangesum-problem-in-pivot-Table/m-p/900660#M313393 swuehl 2015-07-07T15:05:16Z Re: Rangesum problem in pivot Table https://community.qlik.com/t5/QlikView/Rangesum-problem-in-pivot-Table/m-p/900661#M313394 <HTML><HEAD></HEAD><BODY><P>RangeSum(Above(TOTAL count(ID_Weld2),0,RowNo(TOTAL)))</P></BODY></HTML> Tue, 07 Jul 2015 15:12:51 GMT https://community.qlik.com/t5/QlikView/Rangesum-problem-in-pivot-Table/m-p/900661#M313394 MK_QSL 2015-07-07T15:12:51Z Re: Rangesum problem in pivot Table https://community.qlik.com/t5/QlikView/Rangesum-problem-in-pivot-Table/m-p/900662#M313395 <HTML><HEAD></HEAD><BODY><P>you are right!</P><P>many thanks for your help!</P></BODY></HTML> Wed, 08 Jul 2015 07:48:24 GMT https://community.qlik.com/t5/QlikView/Rangesum-problem-in-pivot-Table/m-p/900662#M313395 2015-07-08T07:48:24Z