(cognos 8.2)
I wanna show current and previous months' amounts of those different product type in a bar diagram.
[The dimension isroduct_Type;The Measure are current_month_amount and previous_month_amount]
[The attachment is Reference below]
Request:
if (current_month_amount>previous_month_amount) then
(Change the current month's bars' color to red)
else
(Change the current month's bars' color to green)
That'all.
How to do it?Thanks a lot!
I wanna show current and previous months' amounts of those different product type in a bar diagram.
[The dimension isroduct_Type;The Measure are current_month_amount and previous_month_amount]
[The attachment is Reference below]
Request:
if (current_month_amount>previous_month_amount) then
(Change the current month's bars' color to red)
else
(Change the current month's bars' color to green)
That'all.
How to do it?Thanks a lot!