Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi tohether,
i had a problem with rangeSum.
I need the cumulated sum for the actual and the previous year.
For the actual year it works fine with:
=rangesum(above(sum([Umsatz.Verkauf (MW)]), 0, rowno()))
What i have to do for the previous year?
Is this not working then?
=RangeSum(Above(Sum({<Jahr = {$(#=only(Jahr)-1)}>} [Umsatz.Verkauf (MW)]), 0, RowNo()))
What is your expression for the Umsatz 2017 column?
sum({<Jahr={$(#=only(Jahr)-1)}>}[Umsatz.Verkauf (MW)])
Is this not working then?
=RangeSum(Above(Sum({<Jahr = {$(#=only(Jahr)-1)}>} [Umsatz.Verkauf (MW)]), 0, RowNo()))
Thanks it's working fine now.