This content has been marked as final. Show 8 replies
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.