https://community.qlik.com/t5/QlikView/How-does-the-pivot-table-accumulate-weekly-calculations/m-p/1768288#M718697 <P>in pivot table, the accumulate button is not available</P><P>use this expression:</P><P>rangesum(before(sum(Qty),0,99))</P><P>Regards</P> Mon, 14 Dec 2020 14:20:28 GMT martinpohl 2020-12-14T14:20:28Z https://community.qlik.com/t5/QlikView/How-does-the-pivot-table-accumulate-weekly-calculations/m-p/1768225#M718695 <P>The below is&nbsp;sales quantity&nbsp;of every week:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 648px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/45604i42DCB56CA5D47AB9/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></P><P><SPAN><BR />I want it to be like this,&nbsp;</SPAN><SPAN>cumulative calculation weekly：</SPAN></P><P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.png" style="width: 648px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/45605i18C4CFBAABE0BED9/image-size/large?v=v2&amp;px=999" role="button" title="2.png" alt="2.png" /></span><BR />But I don't know how to write the formula.</SPAN></P><P>I use the formula:sum(total&lt;Code&gt;Qty)</P><P>But the result is the below:</P><P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3.png" style="width: 648px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/45606i969724A3041B84E6/image-size/large?v=v2&amp;px=999" role="button" title="3.png" alt="3.png" /></span><BR />How can I write the formula?</SPAN></P> Mon, 14 Dec 2020 09:44:11 GMT https://community.qlik.com/t5/QlikView/How-does-the-pivot-table-accumulate-weekly-calculations/m-p/1768225#M718695 Nora104 2020-12-14T09:44:11Z https://community.qlik.com/t5/QlikView/How-does-the-pivot-table-accumulate-weekly-calculations/m-p/1768273#M718696 <P>Hi,</P><P>Maybe try to check 'Accumulate' box in Expression tab.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="T1.png" style="width: 307px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/45614i518735892A47364E/image-size/medium?v=v2&amp;px=400" role="button" title="T1.png" alt="T1.png" /></span></P><P>&nbsp;</P> Mon, 14 Dec 2020 13:20:00 GMT https://community.qlik.com/t5/QlikView/How-does-the-pivot-table-accumulate-weekly-calculations/m-p/1768273#M718696 sergio0592 2020-12-14T13:20:00Z https://community.qlik.com/t5/QlikView/How-does-the-pivot-table-accumulate-weekly-calculations/m-p/1768288#M718697 <P>in pivot table, the accumulate button is not available</P><P>use this expression:</P><P>rangesum(before(sum(Qty),0,99))</P><P>Regards</P> Mon, 14 Dec 2020 14:20:28 GMT https://community.qlik.com/t5/QlikView/How-does-the-pivot-table-accumulate-weekly-calculations/m-p/1768288#M718697 martinpohl 2020-12-14T14:20:28Z