Question Jacinto Busquets · Apr 6, 2023 I need to group two or more values into one. What is the right syntax ? WITH [DIMENSIONS].[GENDERCAL] AS [Gender].[H1].[Gender].Currentmember WHEN [Gender].[H1].[Gender].[F] THEN 'FEMALE' WHEN [G How can I create a calculated member in Analyzer using MDX for the following logic? WHEN 'F' THEN 'FEMALE'WHEN 'Female' THEN 'FEMALE'WHEN 'M' THEN 'MALE'WHEN 'Male' THEN 'MALE'WHEN 'U' THEN UNDIFFERENTIATED'WHEN 'UN' THEN UNDIFFERENTIATED'WHEN 'Undifferentiated' THEN UNDIFFERENTIATED'ELSE 'OTHER'END #Analyzer #MDX #InterSystems IRIS BI (DeepSee) 0 2 0 226