Above Function in chart

[brijesh1991]

Hi,

I want to create a column  as shown below:

I want to do (Current Row -  Above Row)

Example: For Date 3rd: Value is 36.5797364796

For Date 4th: 65.4757850231-365797364796

And so on.

Above function is not working in my straight table expression. Can you flash your help, please?

Date	Value	Want to create this column
11/03/14	36.5797364796	36.5797364796
11/04/14	65.4757850231	28.8960485435
11/05/14	101.4748550767	35.9990700536
11/06/14	122.1616684673	20.6868133906
11/07/14	144.5671988313	22.405530364
11/09/14	153.3039131106	8.7367142793
11/10/14	218.3902162795	65.0863031689
11/11/14	249.7548325125	31.364616233

[brijesh1991 · Accepted solution]

sum

( Value) - above( sum( Value ))

worked!

[its_anandrjs]

Hi,

Write this expression

Below(sum(Value)) - sum(Value)

Regards

Anand