Hi All,
I've been able create a waterfall chart with the help of some posts here already, but now I'd like to kick it up a notch.
Here is my current info.
Dimension: %key_Location_Code
Expression: sum[Extended Revenue]
Bar Offset: if(RowNo()=1 or RowNo()= count(DISTINCT %key_Location_Code)+1 ,0,RangeSum(Above(sum([Extended Price]),1,RowNo()-1)))
I am trying to get the prior year's revenue as the first column, the current year as the last, and the change in revenue by location in between the two. I haven't been able to get the data all in the same chart.
I have attached a picture of two charts, side by side that I hope will help.
Thanks!