5 Replies Latest reply: Nov 16, 2015 10:16 AM by Crystle Stamper RSS

    Show Increase/Decrease over yrs in chart

    Crystle Stamper

      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.

       

      YearsSum of CostIncrease/DecreaseLogic for Increase/Decrease Formula
      2009$100$0None - 2009
      2010$400$3002009 - 2010
      2011$600$2002010 - 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!