Above Function

[fheidenstecker]

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

[swuehl · Accepted solution]

Try with the TOTAL qualifier:

sum(Betrag)- above(TOTAL sum( Betrag ))

[#3]

try this

sum( Sales )  - above( sum( Sales ))

or this one

above( sum( Sales )) - sum( Sales ) 

[#4]

PFA.

Hope it helps!

[fheidenstecker]

Thats was FAST!

Thanks swuehl and Shyamal Pandit

[er_mohit]

See the attached file