Hello everyone,
would you be so kind and help me, please?
In one application I have graph, where the Reference line is set by using expression. This Reference line depends on two filters: "Region" and "Business Segment".
"Region" includes : EUROPE-WEST, EUROPE-EAST, APAC-MEA, USC, LATIN AMERICA
"Business Segment" includes: 8 diferent segments
For all data in filters are set different targets wrote as inline tables in Data loading editor.
My script works well but not completelly acording my requirement: when I select "Region"EUROPE-WEST abd EUROPE-EAST together the reference line of target has to correspond to EUROPE-EAST target.
I wanted to implement expression with "and", on the base which the cobination of "Regions" will included (highlighted in red), but it does not work:
=If(IsNull([Business Segment (M)]),
if(IsNull(Region),Target,
If(Region='EUROPE-WEST',TargetEUROPEWEST,
If(Region='EUROPE-EAST',TargetEUROPEEAST,
If(Region='EUROPE-EAST' and Region='EUROPE-WEST',TargetEUROPEEAST,
If(Region='APAC-MEA',TargetAPACMEA,
If(Region='USC',TargetUSC,
If(Region='LATIN AMERICA',TargetLATINAMERICA)))))),
if(IsNull(Region),STarget,
If(Region='EUROPE-WEST',STargetEUROPEWEST,
If(Region='EUROPE-EAST',STargetEUROPEEAST,
If(Region='EUROPE-EAST' and Region='EUROPE-WEST',TargetEUROPEEAST,
If(Region='APAC-MEA',STargetAPACMEA,
If(Region='USC',STargetUSC,
If(Region='LATIN AMERICA',STargetLATINAMERICA)))))))
Can you help me with right condition under which I can see EUROPE-EAST target, when I select regions 'EUROPE-EAST' and 'EUROPE-WEST'?
Thank you in advance for your help.
B.R.,
Monika
