Need help on Dimension Grouping

[sivaprasadv]

Hi Folks,

I need help on dimension grouping where I have data attached like file attachment, I need it as groups like GroupA, GroupB, Group C and Others. If, CID are CN,IN,BNG,PAK those are "Group A", if CID are SA then those are "Group B",if CID are  US then those are "Group C" and remaining are "Others". So here I need calculation expression to get result like above.

Thanks

[tresesco · Accepted solution]

Try like:

Pick(Match(CID, 'CN','IN','BNG','PAK', 'SA', 'US')+1,
             'Others', 'Group A','Group A','Group A','Group A','Group A', 'Group B', 'Group C')   as Group

[sivaprasadv]

Hi Tresesco,

Thanks for reply and helping,please help me like this for all learners like me....

just a small correction updating the expression for my requirement and please make a note this

<!––

Pick(Match(CID, 'CN','IN','BNG','PAK', 'SA', 'US')+1,
             'Others', 'Group A','Group A','Group A','Group A', 'Group B', 'Group C')

!––>

this one works exactly what I want,once again thank you so much