Customize filter box

[FlaminioIta88]

Hello,

I need to customize the option of a filter. I have a dimension like this:

CITIES:

- Rome

- Paris

- New York

- Boston

In the filter I want to create 2 groups that contains it:

- Europe (Paris, Rome)

- US (New York, Boston)

I know it's possible because I did this in the past but I forgot how to do it (maybe an IF function?)

Thanks

[sergio0592]

Hello,

You can try with :

=if(match(City,'Paris','Rome'),'Europe','US')

[BrunPierre]

Hi, something like this leaving room for further grouping.

If(Match(CITIES,'Paris','Rome'),'Europe',
If(Match(CITIES,'New York','Boston'),'US'))