topic Re: Accumulation - Pivot Chart in QlikView https://community.qlik.com/t5/QlikView/Accumulation-Pivot-Chart/m-p/378491#M572323 <HTML><HEAD></HEAD><BODY><P>If you've got Customer and OrderNo as dimensions, try</P><P></P><P><EM>=rangesum(above(sum(Sales),0,RowNo()))</EM></P></BODY></HTML> Thu, 16 Aug 2012 14:08:24 GMT swuehl 2012-08-16T14:08:24Z Accumulation - Pivot Chart https://community.qlik.com/t5/QlikView/Accumulation-Pivot-Chart/m-p/378490#M572322 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I need to have a column that accumulates sales by Customer and not just a rolling full accumulation! Please see the picture attached so you can see what I need to achieve... Any help would be greatly appreciated</P><P></P><P><IMG __jive_id="20298" class="jive-image-thumbnail jive-image" onclick="" alt="Accumulation.png" src="https://community.qlik.com/legacyfs/online/20298_Accumulation.png" width="450" /></P></BODY></HTML> Thu, 16 Aug 2012 12:54:34 GMT https://community.qlik.com/t5/QlikView/Accumulation-Pivot-Chart/m-p/378490#M572322 2012-08-16T12:54:34Z Re: Accumulation - Pivot Chart https://community.qlik.com/t5/QlikView/Accumulation-Pivot-Chart/m-p/378491#M572323 <HTML><HEAD></HEAD><BODY><P>If you've got Customer and OrderNo as dimensions, try</P><P></P><P><EM>=rangesum(above(sum(Sales),0,RowNo()))</EM></P></BODY></HTML> Thu, 16 Aug 2012 14:08:24 GMT https://community.qlik.com/t5/QlikView/Accumulation-Pivot-Chart/m-p/378491#M572323 swuehl 2012-08-16T14:08:24Z Re: Accumulation - Pivot Chart https://community.qlik.com/t5/QlikView/Accumulation-Pivot-Chart/m-p/378492#M572324 <HTML><HEAD></HEAD><BODY><P>Swuehl, that doesn't appear to work! That is what I had tried before...</P></BODY></HTML> Thu, 16 Aug 2012 14:29:39 GMT https://community.qlik.com/t5/QlikView/Accumulation-Pivot-Chart/m-p/378492#M572324 2012-08-16T14:29:39Z Re: Accumulation - Pivot Chart https://community.qlik.com/t5/QlikView/Accumulation-Pivot-Chart/m-p/378493#M572325 <HTML><HEAD></HEAD><BODY><P>If you have two dimensions in a pivot table, both dimensions not pivoted to the top, or a straight table with dimension values sorted appropriately, I think it should work. See attached.</P></BODY></HTML> Thu, 16 Aug 2012 14:39:04 GMT https://community.qlik.com/t5/QlikView/Accumulation-Pivot-Chart/m-p/378493#M572325 swuehl 2012-08-16T14:39:04Z