Help on Crosstab report

[2328]

In crosstab report in summary fields, I should produce one value based on 2 filed values(1.Ratio ,2.Color)
On the top of the color I need see the ratio.
Right now I am showing 2 fields(0:0 crRed)
but user wants to see only one value

[COLOR=red ] and above the color he wants to see another field value

 

[lbass]

What datatype is your color field?

-LB

 

[2328]

Thanks you very much Lbass

Both are strings
I am using XI