You are handling complicated structure and I cannot dig in very in detail, but still need "bridge" between two sources" which is "Client ID" I believe.
Not sure side effect on Viz by adding Client ID to two charts, but at least value seems closer.
Shin...it's really close! Two questions from your workbook attachment...
- Why, when you hover over the bar in "Action Change - Question" worksheet that it shows each individual client (as a mini-bar) rather than one aggregate value?
- Related to #1, the purple bar (showing the change between the first two) is supposed to be the sum of all changes. You'll see that when you hover over it, like the other bars...it's made up of mini-bars for each client.
If we can get these back to aggregates...that's it. Can you help?
Nevermind!!! I did it! I just changed the CliendID to an Attribute.
You're the best!!!