April 6, 2016 at 9:57 am
Hi Dears,
i m having following table
category value
aaa 100
bbb 200
ccc 300
using this table for chart report .
i need to show report with different colors for each category.
my requirment is
if category = aaa and value is positve means need red color,
category = aaa and value is negative means need black color for "aaa" category
if category = ccc and value is positve means need blue color,
category = ccc and value is negative means need red color for "ccc" category
if category = bbb and value is positve means need green color for "bbb" category
i have tried nested iif statement. but i m unable to get it.
could u please provide solution for this..?
kind regards,
Kanna
April 6, 2016 at 10:29 pm
Personally, I would put the logic into the SQL code you are using to get the data which would add a column to the data that is the colour (or RGB code) you wish to use. Then all you need to do is to use that column for the colour in the chart instead of a difficult to debug (as you are finding) series of nested IIF statements
April 7, 2016 at 7:02 am
Thanks for your response.
if single color need means we can go with chart level itself. but in case of multiple colors need means..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply