How to do a YTD calculation

[tim_leijen]

Hi all,

After reading some of the posts on YTD calculations, I came to the below formula, however it seems I've done something wrong.

Any idea where I made a mistake in this formula?

[sunny_talwar · Accepted solution]

Before and ColumnNo() are used in Pivot table... try with Above and RowNo() instead

RangeSum(Above(Sum({<GL_1 = {VOL}, Dimension = {RFC}>} Data), 0, RowNo()))

[tim_leijen]

Thanks Sunny! It worked!