Accumulation in Pivot - need help!

[slwasson]

I am unable to create YTD accumulation in a pivot.  I've read many previous threads on the topic, but nothing seemed to provide the answer I need.  Attached is a file containing some data, a pivot with incorrect YTD figures, and a screenshot from Excel of what the data should be.  Any help would be most appreciated!

[swuehl · Accepted solution]

Try as expression in your pivot table

=aggr(rangesum(above(sum(Sales),0,rowno())),Year,Date)

[slwasson]

Thank you so very much - it works perfectly! 

[marthacano01]

Thank you!! you save my life!!