Grouping within dimension

[WillemRR]

Hi,

I have a dimension called 'Chains'. I am trying to group 'Be', 'Nl' and 'Lu' as Beneluxe. Does anyone know how this works?

[mjht]

You could use a Match function  in your load script

if (match(chains, 'Be', 'Nl' , 'Lu') > 0 , 'Beneluxe', chains) as chains