Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
HI,
It could be possibly just need to the Sum the value in the above function?
Sum(Cost)-Above(Sum(Cost))
Mark
Hi,
Add another expressions,
Sum(Cost)-Above(Cost)
Mark
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?
Have you made selections in the Year field or even without the selection the result is not the one desired?
HI,
It could be possibly just need to the Sum the value in the above function?
Sum(Cost)-Above(Sum(Cost))
Mark
Yes, that worked. It needed the value to be summed in order to calculate the above().
Thank you!