I've attached a workbook with what I hope is your solution.
To get the grey bars in your chart you need to remove the current sales from the cumulative (see sheet 3 how this works) then add sales and this cumulative-sales field to the view and set measure names to colour.
Then create another running total of sales to get the actual YTD total.
example workbook attached, let me know if you have any questions
Stacked Bar example.twbx 453.3 KB
Brilliant stuff Steve.
I was thinking about this from long time but I am still not able to figure out how to do this. I have the logic in mind but not able to put in code.
You're very welcome, glad to help.
I am attaching the workbook in which I have done this. Don't mind its just for thread owners reference in case if thread owner fails to understand LOD that you have used.
Your calculation and Measure Name and Measure Values done the trick. This was something new for me the way you used it.
Thanks and Regards,
Stacked Bar example-Ashish.twbx 311.5 KB