match function in Add calculated dimension

[narender123]

Hi All,

I am using match function in straight table(in add calculated dimention).But my match function is not properly working as per my condition.

Straight table dimention>add calculated dimetion

=if(CPC_CODE='C473','XYZ',

if(CPC_CODE='C430','pqr',

if(match(CPC_CODE,'C4241'),'A',

if(match(CPC_CODE,'C423'),'B',

if(match(CPC_CODE,'C4301','C4302'),'C',

if(match(CPC_CODE,'C4301','C473','C4302','C430','C473'),'D'

))))))

Result is showing

XYZ

pqr

A

B

C

but not showing D.I  want to show all condition.

Because in match function for D : CPC_CODE =4310 and 4302 is repeating as we have used CPC_CODE =4310 and 4302 in match function for C.So Match function is not working where CPC_CODE already used in other case.Pls tell what i have to do.Or there is any other function to solve this??

[narender123]

I am making a group of cpc_code, so with these group condition i will produce a name.

if(cpc_code 4301 and 4302  - i want

cpc group          value

A                   30

[tresesco]

Now I notice, you want single member to be part of seperate groupings. For this you have to work in the script; kind of generic association for some members. Try to upload your sample app with sample data, would be easier to help you.