Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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