Crosstab conditional style issue

[tomixmm]

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