Rather than creating separate sets for each distribution channel, have you thought of using a Case statement (or IF statement if there's more than one condition that puts a sub-category in a distribution channel)?
I've attached an example using superstore data where the field 'Distribution channel' is calculated using a case statement.
Let me know if this doesn't provide a solution you can use.
Case example.twbx 465.5 KB
thank you for your response!
Unfortunately I use cube data, so I cannot simply apply the dimensions or sub-categories to the case statement.
Further, the structure looks like the following:
I have one main category (cost centers/Kostenstellen). This dimension includes several subcategories for instance (Kostenstelle). Under this sub-category, we have all our stores, the online shop, wholesale stores etc.
I want to assort some of the stores to a set called "retail". Other cost centers should form the set called "wholesale" and so forth.
Do you have any idea how to apply these sets to a graph?