Hi,
I am working on a bar graph where in I want to do some conditional styling.
Say the graph is like- Production of cars across car models
Here I am DEFINING a field for styling, which takes values depending on the car model
E.g MODEL_VAL/A1 = IF CAR EQ 'MERC' THEN 'M'
ELSE IF CAR EQ 'BMW' THEN 'B';
I want another styling to be done which is again dependent on car model, plus production amount.
E.g PROD_VAL/A2 = IF CAR EQ 'MERC' AND PRODUCTION GT 1000 THEN 'P1'
ELSE IF CAR EQ 'BMW' AND PRODUCTION GT 500 THEN 'P2';
Both these fields are mutually exclusive.
MODEL_VAL will always have a value.
But when any condition in PROD_VAL also is satisfied, the styling done by MODEL_VAL does not reflect in the graph.
Please suggest if the above method is correct and how I should tackle this issue.
Thanks.
WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML