**bleep**: NoConcatenate LOAD Date,Plant,Item,Value, if(Previous(Date)=Date and Previous(Item)=Item and Previous(Plant)=Plant , RangeSum(Value,Peek('Cummulative Sales')),Value) as [Cummulative Sales] Resident Data Order by Date,Plant,Item;
drop Table Data;
you can create script like this.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution. If you want to go quickly, go alone. If you want to go far, go together.