Stacked bars in waterfall chart

[nicrbe55]

Hi all,

I'm hoping to find a way to make this possible - I have a metric, say units sold, with another metric that describes the variation from the target units sold. I'd like to have those two metrics stacked as columns, but displayed in "waterfall" format through the weeks of the month. Is there a way to do this in report studio?

Also, is there a way to overlay a line chart on top of a waterfall, like the combination charts? I've tried finding a way to get this to work with this style of chart and haven't found it if there is a way. Thanks!

Edit: I've been rethinking this as probably not the best way to go about it. As a followup question, is there a way to cluster stacked columns in a chart in report studio? I would stack the two metrics for current, do the same for prior, then cluster those two columns. Possible?