8 Replies Latest reply: Jun 6, 2014 2:19 PM by Jacob Kean RSS

    Percent change in bar chart

    Michael Hassinger

      I have a bar chart which shows sales by year. Each bar is a simple Sum(Sales) expression.

       

      As a value on the data point, I want to not only display the dollar amount, but also the percentage change from the last year.

       

      So if my sales were: 2012 = 50, 2013 = 75, 2014 = 60, I'd want to see the following three values over each bar:

       

      $50 / N/A     $75 / +50%     $60 / -20%

       

      I have created a 2nd expression and disabled bar, kept show value on data point, but I'm not quite getting the right set analysis and formula to get the correct percentage to show.

       

      Any ideas?