Filter with If statement

[louise119]

I use an if statement for my filter.
Is there a way to get just the selected Region value in the case below?

ex) if (Region='US' or Region='Canada' or Region='China', Region)

[Kushal_Chawda · Accepted solution]

@louise119  you can use filter with expression

=aggr(if (match(Region,'US' ,'Canada' ,'China'), Region),Region)

[louise119]

Thank you so much.

Can I use the expression?

=aggr(if (match(Region,'North America' ,'South America' ,'Asia'), Country),Country)

[Kushal_Chawda]

@louise119  Yes. but you need to include Region as well in Aggr

=aggr(if (match(Region,'North America' ,'South America' ,'Asia'), Country),Country,Region)

[louise119]

Thank you so much.
One more thing...

I use this expression, but the filter was display only 'Japan'.
Do you know the reason why...??

expression：
=aggr(if (match(Region,'USA','Japan','Germany'), Region),Region)