topic cumulative view in a pivot in Insight Advisor https://community.qlik.com/t5/Insight-Advisor/cumulative-view-in-a-pivot/m-p/2114619#M282 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RobMazaheri_0-1694097930886.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115833i901FAD1FB730AD03/image-size/medium?v=v2&amp;px=400" role="button" title="RobMazaheri_0-1694097930886.png" alt="RobMazaheri_0-1694097930886.png" /></span></P> <P>&nbsp;</P> <P>trying to get a cumulative view in a pivot using the below statement but its not working. someone has advised that if there is a 0 then the formula cannot see past this ? is this correct and if so how do i get around his ??</P> <DIV>RangeSum (Above (</DIV> <DIV>SUM(</DIV> <DIV><SPAN> {&lt;</SPAN></DIV> <DIV>&nbsp; &nbsp; COMMISSIONING_RCVD_DT ={"&gt;=01/04/2023"}</DIV> <DIV>&nbsp; &nbsp; &gt;}SUBMITTED_THP)</DIV> <DIV><SPAN> ,0,RowNo()))</SPAN></DIV> Thu, 07 Sep 2023 14:47:46 GMT RobMazaheri 2023-09-07T14:47:46Z cumulative view in a pivot https://community.qlik.com/t5/Insight-Advisor/cumulative-view-in-a-pivot/m-p/2114619#M282 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RobMazaheri_0-1694097930886.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115833i901FAD1FB730AD03/image-size/medium?v=v2&amp;px=400" role="button" title="RobMazaheri_0-1694097930886.png" alt="RobMazaheri_0-1694097930886.png" /></span></P> <P>&nbsp;</P> <P>trying to get a cumulative view in a pivot using the below statement but its not working. someone has advised that if there is a 0 then the formula cannot see past this ? is this correct and if so how do i get around his ??</P> <DIV>RangeSum (Above (</DIV> <DIV>SUM(</DIV> <DIV><SPAN> {&lt;</SPAN></DIV> <DIV>&nbsp; &nbsp; COMMISSIONING_RCVD_DT ={"&gt;=01/04/2023"}</DIV> <DIV>&nbsp; &nbsp; &gt;}SUBMITTED_THP)</DIV> <DIV><SPAN> ,0,RowNo()))</SPAN></DIV> Thu, 07 Sep 2023 14:47:46 GMT https://community.qlik.com/t5/Insight-Advisor/cumulative-view-in-a-pivot/m-p/2114619#M282 RobMazaheri 2023-09-07T14:47:46Z