topic Use BEFORE in PivotTable in QlikView https://community.qlik.com/t5/QlikView/Use-BEFORE-in-PivotTable/m-p/282443#M496299 <HTML><HEAD></HEAD><BODY><P>Hi</P><P style="font-family: Tahoma; font-size: 9.0pt;">I have difficulty withthe task of calculating the cumulative total in a PivotTable.</P><P style="font-family: Tahoma; font-size: 9.0pt;"><SPAN lang="ru">I use formula: "<EM>RangeSum(Before(</EM></SPAN><EM><SPAN lang="en-US"> total </SPAN></EM><SPAN lang="ru"><EM>sum(TestValue),0,9999))</EM>" but it does not work if </SPAN><SPAN lang="en-US">in </SPAN><SPAN lang="ru">PivotTable explanded different dimensions.</SPAN></P><P lang="en-US"></P><P lang="en-US" style="font-family: Tahoma; font-size: 9.0pt;">example in attachment</P></BODY></HTML> Tue, 17 Jan 2012 12:39:07 GMT 2012-01-17T12:39:07Z Use BEFORE in PivotTable https://community.qlik.com/t5/QlikView/Use-BEFORE-in-PivotTable/m-p/282443#M496299 <HTML><HEAD></HEAD><BODY><P>Hi</P><P style="font-family: Tahoma; font-size: 9.0pt;">I have difficulty withthe task of calculating the cumulative total in a PivotTable.</P><P style="font-family: Tahoma; font-size: 9.0pt;"><SPAN lang="ru">I use formula: "<EM>RangeSum(Before(</EM></SPAN><EM><SPAN lang="en-US"> total </SPAN></EM><SPAN lang="ru"><EM>sum(TestValue),0,9999))</EM>" but it does not work if </SPAN><SPAN lang="en-US">in </SPAN><SPAN lang="ru">PivotTable explanded different dimensions.</SPAN></P><P lang="en-US"></P><P lang="en-US" style="font-family: Tahoma; font-size: 9.0pt;">example in attachment</P></BODY></HTML> Tue, 17 Jan 2012 12:39:07 GMT https://community.qlik.com/t5/QlikView/Use-BEFORE-in-PivotTable/m-p/282443#M496299 2012-01-17T12:39:07Z Use BEFORE in PivotTable https://community.qlik.com/t5/QlikView/Use-BEFORE-in-PivotTable/m-p/282444#M496300 <HTML><HEAD></HEAD><BODY><P> hi,</P><P>use above instead of before</P></BODY></HTML> Tue, 17 Jan 2012 13:13:08 GMT https://community.qlik.com/t5/QlikView/Use-BEFORE-in-PivotTable/m-p/282444#M496300 vijay_iitkgp 2012-01-17T13:13:08Z Re: Use BEFORE in PivotTable https://community.qlik.com/t5/QlikView/Use-BEFORE-in-PivotTable/m-p/282445#M496301 <HTML><HEAD></HEAD><BODY><P lang="en-US" style="font-family: Tahoma; font-size: 9.0pt;">Hello</P><P lang="en-US" style="font-family: Tahoma; font-size: 9.0pt;">I checked this operation of portrate-report with above function. it does not work too (if in PivotTable explanded different dimensions)</P><P lang="en-US"></P><P lang="en-US" style="font-family: Tahoma; font-size: 9.0pt;">new example in attachment</P></BODY></HTML> Tue, 17 Jan 2012 13:47:28 GMT https://community.qlik.com/t5/QlikView/Use-BEFORE-in-PivotTable/m-p/282445#M496301 2012-01-17T13:47:28Z