Hi,
I have a requirement to change color of fact cells depending on element value that not exist in the crosstab layout.
When I tried to add the element to row or column edge unfortunately conditional style does not work correctly, I need to change a colour of exact cells, not entire row or column.
Would someone help me to solve the issue?
Attached my sample report specification.
Tabular Data:
Product line Year Quantity Color
Camping Equipment 2011 6 903 764 Red
Camping Equipment 2010 5 895 053 Green
Golf Equipment 2011 1 297 793 Green
Golf Equipment 2010 1 092 982 Green
I need the intersection of Camping Equipment and 2011 cell colour was red, the other cells - green.
Quantity 2010 2011
Camping Equipment 5 895 053 6 903 764
Golf Equipment 1 092 982 1 297 793
Thank you.
Tomasz