Is it possible to color any random row in cross table

[Mansi Joshi]

Dear All,

In the attached screen shot I need to color HCS, LS, Other and Total rows in cross table.

All the Vertical Axis values(HCS,LS, USCAN, Africa etc) are coming from single column called Region.

I am not able to achieve it through Color properties of cross table, request you to please help if it is feasible.

Thanks in advance.

Thanks & Regards,

Mansi Joshi

[Richard Pobi]

Color properties > Add > select color scheme grouping > select values on your left > Add to your right > OK > color mode = fixed > select white color > Add Rule > Rule type: Boolean expression > Value > write this in the expression: Mod(RowId(),2)=0 > OK > OK > select Yellow color

[Mansi Joshi]

Thank you so much Richierich. :) This way it works.