Alternate color in a cross tab

[jcao0000]

I am wondering can I specify alternate color in a cross tab.

My table contains:
Row: Department ID (1000, 1100, 1200....)
It contains sub row showing Y07, Y06 and variance.
Column: week number
Summary field: Sales value

It looks like:
Sales
1000 Y07 2000
Y06 1800
Var 200
1100 Y07 3000
Y06 2500
Var 500

What I want is to have silver color for Y07 row, yellow for Y06 and green for Var row.

How can I make it? Thanks advance for the help!

 

[lbass]

What is your CR version? If you look in the crosstab expert, do you see two row fields and on summary field or only one rowfield with three summary fields?

-LB

 

[jcao0000]

My version is 11.

There is only one row field (Dept ID) and 3 summary fields (Y07, Y06 and Var).

Thanks

 

[lbass]

In that case, you can just select the summary label and the summary and right click->border->background->select the color you wish. Repeat for the other two summaries.

-LB