Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I would like to fix a RGB Color "1429a0" for the Brand Mazada. If Brand is Mazada then RGB "1429a0 " else other colour.
I am writing this expression in Title under Bell Chart, Hence not possible to use a Master Dimension colour.
Any Work arounds. Please help.
Below is the expression:
= 'MAZADA'&
DUAL(
NUM(SUM({<BRAND={'MAZADA'},BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV)
/
SUM(TOTAL<PRICESEG, COUNTRY,[Year Month Base],[Year Quarter Base],[Year Half Base]>{<BRAND,BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV),'#,##0.0%')
& '(' &
NUM(SUM({<BRAND={'MAZADA'},PRICESEG,BrGrp1,BrGrp2, [Year Base],[Year Half Base],[Year Quarter Base],[Year Half Base (YYYYHH)] ,[Year Month Base], [Year Quarter Base (YYYYQQ)], Year_Offset={"0"},[Year Month_Offset]={"0"}, [Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV/$(pSwt_Unit))
/
SUM({<BRAND={'MAZADA'},PRICESEG,BrGrp1,BrGrp2, [Year Base],[Year Half Base],[Year Quarter Base],[Year Half Base (YYYYHH)], [Year Month Base], [Year Quarter Base (YYYYQQ)], Year_Offset={"0"},[Year Month_Offset]={"0"}, [Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}RR/$(pSwt_Unit)),'#,##0')
&')' ,
NUM(SUM({<BRAND={'MAZADA'},BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV)
/
SUM(TOTAL<PRICESEG, COUNTRY,[Year Month Base],[Year Quarter Base],[Year Half Base]>{<BRAND,BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV),'#,##0.0%')
)