1 of 1 people found this helpful
So one way to do this is to use a Dual Axis...
first I created a second axis for your stacked bars (with the measure still %age of total sales). I then removed the Sub-Category from the VizLoD (i.e. removed from colour shelf) on the second axis. I then changed the mark type to Gantt (and made the transparency 0%...so we won't see the marks). I then add the sales as a label (not %age of total, but SUM of Sales). so the Gantt marks are at 100%, but the label is the SUM of sales.
I then Dual Axis and Sync the Axis...and (hopefully) we have the solution!
Hope that helps, and makes sense.
Thanks a ton Simon for the reply. It was indeed helpful and it served my purpose
I think I got it.