https://community.qlik.com/t5/QlikView/Show-Average-in-Horizontal-Pivot-Table/m-p/1538360#M457217 <P>Good morning specialists!</P><P>I need to do a horizontal (left to right) accumulation in a triangular pivot table.</P><P>Showing you starting table and desired result. Anyone suggestions how to go about this problem?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Start result" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5017i403338C77E0F4DB2/image-size/large?v=v2&amp;px=999" role="button" title="Start table.PNG" alt="Start result" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Start result</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Desired table" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5018i5C11EB7F959F0F04/image-size/large?v=v2&amp;px=999" role="button" title="Result table.PNG" alt="Desired table" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Desired table</span></span></P> Sat, 16 Nov 2024 21:29:16 GMT hansdevr 2024-11-16T21:29:16Z https://community.qlik.com/t5/QlikView/Show-Average-in-Horizontal-Pivot-Table/m-p/1538360#M457217 <P>Good morning specialists!</P><P>I need to do a horizontal (left to right) accumulation in a triangular pivot table.</P><P>Showing you starting table and desired result. Anyone suggestions how to go about this problem?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Start result" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5017i403338C77E0F4DB2/image-size/large?v=v2&amp;px=999" role="button" title="Start table.PNG" alt="Start result" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Start result</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Desired table" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/5018i5C11EB7F959F0F04/image-size/large?v=v2&amp;px=999" role="button" title="Result table.PNG" alt="Desired table" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Desired table</span></span></P> Sat, 16 Nov 2024 21:29:16 GMT https://community.qlik.com/t5/QlikView/Show-Average-in-Horizontal-Pivot-Table/m-p/1538360#M457217 hansdevr 2024-11-16T21:29:16Z https://community.qlik.com/t5/QlikView/Show-Average-in-Horizontal-Pivot-Table/m-p/1538374#M457218 <P>Try it with something like this:</P><P>rangesum(before(sum(YourValue), 0, columnno()))</P><P>- Marcus</P> Fri, 01 Feb 2019 11:34:50 GMT https://community.qlik.com/t5/QlikView/Show-Average-in-Horizontal-Pivot-Table/m-p/1538374#M457218 marcus_sommer 2019-02-01T11:34:50Z https://community.qlik.com/t5/QlikView/Show-Average-in-Horizontal-Pivot-Table/m-p/1538387#M457219 <P>Brilliant, Marcus!! Thank you very much!!</P> Fri, 01 Feb 2019 11:57:57 GMT https://community.qlik.com/t5/QlikView/Show-Average-in-Horizontal-Pivot-Table/m-p/1538387#M457219 hansdevr 2019-02-01T11:57:57Z