Show Increase/Decrease over yrs in chart

[crystles]

I have a bar chart with a Dimension of Years, and an Expression of Sum(cost)

I want to have a value on a line, over the bars, that shows how the bar values (Sum of costs for each year) increases each year.

So say, for 2009 I have $100 for 2010 I have $400 and for 2011 I have $600.

Years	Sum of Cost	Increase/Decrease	Logic for Increase/Decrease Formula
2009	$100	$0	None - 2009
2010	$400	$300	2009 - 2010
2011	$600	$200	2010 - 2011

I feel like there should be a simple answer, but I cant seem to think of a simple formula to achieve the desired output as an expression.

Any help would be greatly appreciated. Thanks!

[Mark_Little]

Hi,

Add another expressions,

Sum(Cost)-Above(Cost)

Mark

[crystles]

I tried the formula and it doesn't show an error, but the chart doesn't show the values for that formula for some reason?

[sunny_talwar]

Have you made selections in the Year field or even without the selection the result is not the one desired?

[Mark_Little · Accepted solution]

HI,

It could be possibly just need to the Sum the value in the above function?

Sum(Cost)-Above(Sum(Cost))

Mark

[crystles]

Yes, that worked. It needed the value to be summed in order to calculate the above().

Thank you!