Hi all,
I have a ctacked bar chart where one of the dimensions is a calculates dimension with the following expression:
=if(InventorySubType='OV',Dual('Short Shipped - OverPlanned',1),
if(match(InventorySubType,'OM','AU') , dual('Short Shipped - OverMade',2),
if(InventorySubType='OC', dual('Short Shipped - OverChange',3),
if(InventorySubType='PL', dual('Short Shipped - Under-Planning',5),
if(InventorySubType='PR',dual('Short Shipped - Under-Production',6),
if(InventorySubType='UD', dual('Short Shipped - Under-Dispatch',4),
if(InventorySubType='OP', dual('Short Shipped - Old Stocks & PFE',7),
if(InventorySubType='MS', dual('Short Shipped - Mill Stock',8),dual('Blank',9)))))))))
I'm trying to personalize this chart with other colors. in other to do that, I've tried to replace the above expression by this one:
=match(if(InventorySubType='OV',Dual('Short Shipped - OverPlanned',1),
if(match(InventorySubType,'OM','AU') , dual('Short Shipped - OverMade',2),
if(InventorySubType='OC', dual('Short Shipped - OverChange',3),
if(InventorySubType='PL', dual('Short Shipped - Under-Planning',5),
if(InventorySubType='PR',dual('Short Shipped - Under-Production',6),
if(InventorySubType='UD', dual('Short Shipped - Under-Dispatch',4),
if(InventorySubType='OP', dual('Short Shipped - Old Stocks & PFE',7),
if(InventorySubType='MS', dual('Short Shipped - Mill Stock',8),dual('Blank',9))))))))), rgb(208,120,87),rgb(221,157,131),rgb(236,201,187), rgb(166,133,83), rgb(196,173,138), rgb(219,205,185), rgb(63,63,63), rgb(139,139,139), rgb(201,201,201))
but it isn't working... Do you have any idea what I might be doing wrong or what can I do to personalize these colors?
Thank you!
Sofia Vaz
