https://community.qlik.com/t5/QlikView/range-sum-in-pivot-table-with-many-dimensions/m-p/1797936#M1211419 <P>Hi</P><P>I need to sum comulative results in pivot table with many dimensions.</P><P>I managed to do it but when I expand dimensions it doesn't work. Is it possible to create dynamic range sum?</P><P>Yellow rows is what I need to achieve (yellow and orange rows):</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ania_1-1617879662123.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52657i62CD02EA01ECD895/image-size/medium?v=v2&amp;px=400" role="button" title="Ania_1-1617879662123.png" alt="Ania_1-1617879662123.png" /></span></P><P>It's cumulative sum per worker.</P><P>I also attach file with example.</P><P>&nbsp;</P> Thu, 08 Apr 2021 11:02:54 GMT Ania 2021-04-08T11:02:54Z https://community.qlik.com/t5/QlikView/range-sum-in-pivot-table-with-many-dimensions/m-p/1797936#M1211419 <P>Hi</P><P>I need to sum comulative results in pivot table with many dimensions.</P><P>I managed to do it but when I expand dimensions it doesn't work. Is it possible to create dynamic range sum?</P><P>Yellow rows is what I need to achieve (yellow and orange rows):</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ania_1-1617879662123.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52657i62CD02EA01ECD895/image-size/medium?v=v2&amp;px=400" role="button" title="Ania_1-1617879662123.png" alt="Ania_1-1617879662123.png" /></span></P><P>It's cumulative sum per worker.</P><P>I also attach file with example.</P><P>&nbsp;</P> Thu, 08 Apr 2021 11:02:54 GMT https://community.qlik.com/t5/QlikView/range-sum-in-pivot-table-with-many-dimensions/m-p/1797936#M1211419 Ania 2021-04-08T11:02:54Z