Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Yes you can use before instead
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