How to group a list of data value in a dimension?

[jim_chan]

Hi guys,

I have a dimension which full of deals. but based on requirement, the deals have to be split or group to BIG deal and Small Deal.

I have created an exmapple here as per attached.

What i want is:

1) Group value ABCD into BIG Deal, rest of it without typing EFGH, will be group into Small Deals.

[tresesco · Accepted solution]

You can use expression like:

=If(Match(Deals, 'a', 'b', 'c', 'd'), 'Big Deals', 'Small Deals')