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!