topic Full Accumulation in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Full-Accumulation-in-Pivot-Table/m-p/435801#M162553 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Is it possible to show "full accumulation" enabled values in Pivot chart?</P><P>If so, how? Kindly help me on this.</P><P></P><P>Regards,</P><P>Vidhya</P></BODY></HTML> Tue, 09 Apr 2013 10:42:10 GMT 2013-04-09T10:42:10Z Full Accumulation in Pivot Table https://community.qlik.com/t5/QlikView/Full-Accumulation-in-Pivot-Table/m-p/435801#M162553 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Is it possible to show "full accumulation" enabled values in Pivot chart?</P><P>If so, how? Kindly help me on this.</P><P></P><P>Regards,</P><P>Vidhya</P></BODY></HTML> Tue, 09 Apr 2013 10:42:10 GMT https://community.qlik.com/t5/QlikView/Full-Accumulation-in-Pivot-Table/m-p/435801#M162553 2013-04-09T10:42:10Z Re: Full Accumulation in Pivot Table https://community.qlik.com/t5/QlikView/Full-Accumulation-in-Pivot-Table/m-p/435802#M162554 <HTML><HEAD></HEAD><BODY><P>there are three types of accumulation</P><P>try the one that suites your needs:</P><P>Above</P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P>sum</P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">) + </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RangeSum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">),1,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RowNo</SPAN><SPAN style="font-size: 8pt;">())) </SPAN></P><P>sum</P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">) + </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RangeSum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Total</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">),1,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RowNo</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;">))) </SPAN></P><P></P><P>check the attached example which clarifies what I'm talking about</P></BODY></HTML> Thu, 18 Jul 2013 13:49:31 GMT https://community.qlik.com/t5/QlikView/Full-Accumulation-in-Pivot-Table/m-p/435802#M162554 ali_hijazi 2013-07-18T13:49:31Z