topic Re: Customize filter box in App Development

Customize filter box

FlaminioIta88 — Thu, 11 May 2023 07:43:52 GMT

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 — Thu, 11 May 2023 07:49:34 GMT

Hello,

You can try with :

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

BrunPierre — Thu, 11 May 2023 08:13:23 GMT

Hi, something like this leaving room for further grouping.

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