Hi,
I have a report which shows : Product_Line, Revenue, Status
Status : calculated on revenue
(case
when [Revenue] <= 100000000 then ('red')
when [Revenue] >= 1000000000 then ('blue')
else ('green')
end)
I have a value prompt (drop down list) in the report page which gives me the option to choose my Product_Line (parameter 'PL').
These Product_Line prompt values should be displayed as red/blue/green (font colur) based on the status condition.....when the users click on the drop down list.
Is there a way I can achieve this in Cognos?
Thanks
dsg