Ytd values using AGGR()?

[Go-Anna]

Hi!

I have a pivot table and would like to show one column with the 'Price' per 'Period' and one column with YTD sum of 'Price' ie ackumulated sum per period.

Can someone help me work out how to achive the desired YTD columns?

Thanks,

[Go-Anna · Accepted solution]

I solved it using range instead 🙂

RangeSum(Before(Sum([Price (SEK)]), 0, ColumnNo()))