Above but take values from left not above

[peisenrot]

Hello, 

I would like to create a pivot table where a have the accumulation done from the values which are shown left of the line and not of above. if there a possibility to do that?

best regards

Pia

[Mark_Winter]

Yes you can use before instead

[peisenrot · Accepted solution]

aggr(rangesum(before(Sum({<Dataset={'NRE History'},DataVersion={'$(NRE_Baseline)'}>} Value)*-1+Sum({<Dataset={'NRE'},Period.Year={'2022'}>} Value)*-1)),
([Period.YearMonth],(NUMERIC, ASCENDING))) doesn't calucalte something