Coloring cells in a Tabulate report

Question

Is it possible to color cells in a Tabulate report based on the values in particular cells? I know you can do this in a JMP data table and you can make a Tabulate report into a data table but the customer would like to color the cells in the Tabulate report directly. I can't figure out a way of doing that.Can anyone help, please?

robert_anderson · Answer

Thanks Wendy, that's very helpful.

Wendy_Murphrey · Answer

I don't think it is possible to color rows in Tabulate.  Below is a workaround that puts the data into a TableBox with colored cells.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );

temp = (dt << Tabulate(
	Show Control Panel( 0 ),
	Add Table(
		Column Table( Grouping Columns( :sex, :marital status ) ),
		Row Table( Grouping Columns( :country, :size ) )
	)
)) << Make Into Data Table;

Column( temp, "size" ) << Set Property(
	"Value Colors",
	{"Large" = 3, "Medium" = 5, "Small" = 7}
) << Color Cell by Value;

rpt = temp << Get As Report;
rpt[Table Box( 1 )] << Set Shade Alternate Rows( 1 ) << Set Column Borders( 1 ) <<
Set Underline Headings( 1 );

New Window( "Tabulate", rpt );