Calculates dimension set analysis or agg function

[#1]

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

[pover]

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.