Hi thanks, it works! But it also messed up my graph a little bit. I received an additional line at the bottom with text with service area names. I also have an additional bar visible in my graph which are products that can not be matched with a PPG and marked as - , bars that are not included in the code selection in the dimension.
How to remove the additional line and bar? (see attachment)
Where can I uncheck the dimension properties "Include null values"? Maybe that resolves the bar issue
And how to deal with words with comma’s in the code, only way is to change the word in the masterfile? (see attachment)
Is there another place where this code can be used, other than the dimension. Because the graph is being messed up a bit with the dimension :). Maybe as an expression in sort?
This expression is already in my sort to dictate the order of the service area, now I want to select in the graph only PPG1, PPG2, PPG3 and Service Area 1 (Factory Defect), Service Area 2 (DEFOA) and Service Area 3 (Field replace-War) only