I have a dataset like this:
Code: Select all
Col1, Col2
0.5, 1.3
1, 2.0
0.6, 2
3, 1
I want to do bar chart for Col1 with condition that bars are red when Col2 > Col1, and green otherwise. In the case above only last pair do not fulfill the condition, so first 3 columns will be red and the last one will be green. So I want to have result simillar to this (different case than data above):

- Chart1.png (12.22 KiB) Viewed 5183 times
My question is how can I construct conditional formatting of one column using comparition with other column? In Report Designer I suceeded only using constant value. Is it possible to use datasource field value for comparition?