I need to create a table that looks like this where the blue, red, and gray bars are predefined values. The orange, yellow, and green bars are also pre-defined values (left) but I also need a duplicate bar next to them that change based on user entries (right). I need the three middle bars to group under one label. I am thinking this may be accomplished with multiple dimensions but I'm not quite sure how to set it up. Any suggestions would be appreciated! I don't want to group the expressions because I need them all visible at the same time.
I get that but I'm not sure how to load the two dimensions. right now I'm getting the equivalent of 6 side by side waterfalls squished into the table. Do I just need one expression that says IF left (left bar) then this value, else that value (for right bar)?
One more question... how do I eliminate the gap between the bars that only use one of the dimensions? I tried suppressing when value is null but it's not responding to that. Also, it won't show grid lines even though I have it set to show them. thoughts on that?