Bar Chart Difference

[#1]

Hi All,

I have the following bar chart.

In the Y axis I have the amount of money spent.

In the X axis I have the Year.

I would like to know which is the function to calculate de difference between one year and another.

lets suppose that in 2011 I spent $100 and on 2012 I spent 200, I want the function that brings to me 200 - 100 = 100 automatically. (as another bar in the chart)

For total accumulated  I use rangesum(above).... but for the difference I don't know which is the function..

thank you all ...

[swuehl · Accepted solution]

You could look into the chart inter record functions, one of them is the above() function you already used.

So try something like

=Sum(Value)-above(Sum(Value))

as expression for your Delta bar.

[#3]

You re right...

It was just in front of my eyes....

Really thanks.