1 of 1 people found this helpful
Would going to the [Age] dimension, create group(s) for the ages, then call that new dimension group by your CASE statement not work?
If not, mock something up using Superstore data to show the problem you're experiencing.
I tried this but the CASE statement doesn't seem to like a grouped field in the argument.
I have attached Superstore example - the issue is in the value selector field.
Superstore example grouped.twbx 505.7 KB
Ah, then you'll need to create your custom groups with a nest IF/THEN
WHEN 'Customer name' THEN [Customer Name]
WHEN 'Segment' THEN [Segment]
WHEN 'Region' THEN
IF [Region] = 'Central' OR [Region] = 'South' THEN 'Group 1'
ELSEIF [Region] = 'West' OR [Region] = 'North' THEN 'Group 2'
That works perfectly - thank you!