Add calculated dimension expression problem

[Surya]

Hi,

in add calculated dimension i need 

IF(WildMatch(BILL_PLANT ,'8502') AND WILDMATCH(MATERIAL_BILL_LONG ,'BL_*','RD_*'),'BARMILL/ROUND',
IF (WILDMATCH(PROD_PLANT,'8502') AND WILDMATCH(PROD_MVT_TYPE,'101','102') AND WILDMATCH(PROD_MATERIAL_LONG,'RD_*') AND WILDMATCH(PROD_MATERIAL_GROUP,'S001','S002'),'ROUND',
IF (WILDMATCH(PROD_PLANT,'8502') AND WILDMATCH(PROD_MVT_TYPE,'101','102') AND WILDMATCH(PROD_MATERIAL_LONG,'BL_*') AND WILDMATCH(PROD_MATERIAL_GROUP,'S001','S002'),'BILLET'))))

how can we do..?

i need individul and sum of both

[sunny_talwar]

---

@Surya wrote:

i need individul and sum of both

---

What exactly do you mean? Can you elaborate using a sample and expected output from the sample?

[Surya]

In add calculated dimension,

if(wildmatch(plant,'8502') and wildmatch(name,'bl_*'),'Bar'  //value 02

if(wildmatch(plant,'8502') and wildmatch(name,'rd_*'),'round'  //value 05

if(wildmatch(plant,'8502') and wildmatch(name,'rd_*','bl_*'),'bar/round'  //value 07

)))

//in line chart 

expression is sum(qty)

[sunny_talwar]

okay, so what is wrong 🙂

[Surya]

WHEN I USE LINE CHART IM GETTING BAR AND ROUND NOT GETTING BAR/ROUND BRO