Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a question regarding the Above Function. I want to calculate the difference between the current line and the previous one.
I expect the result to be as in this Excel Table
I simply can't get it to work. The problem I think is the rowno starts again at 1, because there are 2 different years (2012,2013)
Does anybody have an idea how to solve this?
Cheers,
Fabian
Try with the TOTAL qualifier:
sum(Betrag)- above(TOTAL sum( Betrag ))
try this
sum( Sales ) - above( sum( Sales ))
or this one
above( sum( Sales )) - sum( Sales )
PFA.
Hope it helps!
Thats was FAST!
Thanks swuehl and Shyamal Pandit
See the attached file