Group Dimenion values

[Anonymous]

Hi All,

I have a dimension called "Company Size" which has the following values  

1 - 9

10 - 99

100 - 249

250 - 499

500 - 999

1000+

UNKNOWN

I would like the dimension "Company Size" to roll up to values and show:

UNKNOWN

Small (1-99)

Mid-Market (100-999)

Enterprise (>1000)

Regards,

Ajinkya

[sunny_talwar · Accepted solution]

May be this..

If(Match([Company Size], '1 - 9', '10 - 99'), 'Small (1-99)',

     If(Match([Company Size], '100 - 249', '250 - 499', '500 - 999'), 'Mid-Market (100-999)',

          If(Match([Company Size], '1000+'), 'Enterprise(>1000)', 'UNKNOWN')))

[vkish16161]

Maybe use ApplyMap in script?