I have a generated filter with cases. I would like to have the result as “xxx, www”. If I generate the filter without the cases before ", ‘,’ " works. But if I add the cases to remove some not needed results, it doesn’t work. How can I have the filter result with a comma?
WHEN [Measures].[Issue type]=“Concept Deliverable”
CASE [Validation method].CurrentHierarchyMember.Name
WHEN “(none)” THEN “”
WHEN “All Validation methods” THEN “”
I would like to have
[Validation method].CurrentHierarchyMember.Name, ‘,’
But I get a syntax error.