I have to do this all the time. Here's how I do it...
Create a parameter for your customer name.
Then create a calculated field called cust v market or something like that.
The field should say, if customer = [customer parameter] then customer else "Market".
I've attached superstore sample for you.
OneVsRest.twbx 390.1 KB
In your case, you would drag cust v market to color and size shelves.
Thanks very much for the help on this.
Your solution would work but would lead me to a similar stage I am currently at - the parameter is then locked to a specific manufacturer in the list. If i then filter to a different manufacturer the chart goes blank.
I was trying to figure out if a parameter/calculated field can be dynamic in the sense that the "if customer = [manufacturer selected in filter]" and when i change my selected manufacturer then the calculation changes.
Doesn't seem to be possible though.
Thank you very much for your help though!
Attached are two solutions: one based on table calculations and one using LoD.
You may build a dashboard where measure names would be covered with Customer/Other labels.
OneVsRest.twbx 405.7 KB
Lukasz, would you mind saving your workbook in 9.1 version too ?