Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey all,
I am wondering how to use a calculated dimensions, so instead of showing all regions, ex. :
Australia
Asia
West Europe
East Europe
it would show for example Australia, Asia, and West Europe together with East Europe as just Europe. Or just Australia and the rest of the world... I was searching a forum for that and trying to find a sollution but nothing works:(
I would appreciate your help,
Beata
The calculated dimension would be something like the following:
if(match(Region,'West Europe','East Europe'),'Europe',Region)
However if you want something like this, it is better to create the group from the script as sometimes it is hard to sort calculated dimensions and the dropdown select doesn't work with calculated dimensions.
Regards.