topic Accumulation in Pivot - need help! in QlikView https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot-need-help/m-p/370670#M574979 <HTML><HEAD></HEAD><BODY><P>I am unable to create YTD accumulation in a pivot.&nbsp; I've read many previous threads on the topic, but nothing seemed to provide the answer I need.&nbsp; Attached is a file containing some data, a pivot with incorrect YTD figures, and a screenshot from Excel of what the data should be.&nbsp; Any help would be most appreciated!</P></BODY></HTML> Wed, 27 Jun 2012 14:27:42 GMT slwasson 2012-06-27T14:27:42Z Accumulation in Pivot - need help! https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot-need-help/m-p/370670#M574979 <HTML><HEAD></HEAD><BODY><P>I am unable to create YTD accumulation in a pivot.&nbsp; I've read many previous threads on the topic, but nothing seemed to provide the answer I need.&nbsp; Attached is a file containing some data, a pivot with incorrect YTD figures, and a screenshot from Excel of what the data should be.&nbsp; Any help would be most appreciated!</P></BODY></HTML> Wed, 27 Jun 2012 14:27:42 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot-need-help/m-p/370670#M574979 slwasson 2012-06-27T14:27:42Z Re: Accumulation in Pivot - need help! https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot-need-help/m-p/370671#M574981 <HTML><HEAD></HEAD><BODY><P>Try as expression in your pivot table</P><P></P><P><EM>=aggr(rangesum(above(sum(Sales),0,rowno())),Year,Date)</EM></P></BODY></HTML> Wed, 27 Jun 2012 15:11:11 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot-need-help/m-p/370671#M574981 swuehl 2012-06-27T15:11:11Z Re: Accumulation in Pivot - need help! https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot-need-help/m-p/370672#M574985 <HTML><HEAD></HEAD><BODY><P>Thank you so very much - it works perfectly!&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 27 Jun 2012 16:07:29 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot-need-help/m-p/370672#M574985 slwasson 2012-06-27T16:07:29Z Re: Accumulation in Pivot - need help! https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot-need-help/m-p/370673#M574987 <HTML><HEAD></HEAD><BODY><P>Thank you!! you save my life!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/love.png" /></P></BODY></HTML> Wed, 23 Oct 2013 06:59:51 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot-need-help/m-p/370673#M574987 marthacano01 2013-10-23T06:59:51Z