You could check the attachment.
Not sure if it's what you mean..
TEST-dim.qvw 148.8 K
Thank you so much for your reply.
What you expressed in the document is correct but that applies only for one condition (A,B,E) and rest are Red.
I have targets for other conditions(Each Row) as well and i want to combine all the conditions so that it will get color to Expression_1 accordingly.
I wanted to know how i can combine all conditions and get final color results in Expression_1
Please suggest and let me know if you need further information.
what's your final chart object is? are you sure it is a pivot table, not a straight one? Is this like
if this is a simple straight chart like that, then you can create another table in your date model with a concatenated key autonumber(Dim1,Dim2,Dim3) and Target value. And create the same key in your main table so it will be connected to your color table in data model
Then if your chart dimensions are the same, you can color code now using
if(Exp1 > Target, green(), red())
Now if this is a pivot chart or your dimensions are different, then things can get ugly.