Hi,

Is it possible to format the subtotal when using ON TABLE SUBTOTAL. I want the total color to be in blue. I checked the forum but could not find anything that will help me out.


SET SUMMARYLINES=NEW
TABLE FILE CAR
PRINT
SALES
BY CAR
ON TABLE SUBTOTAL AVE. SALES
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
$
TYPE=DATA,
COLUMN=N2,
COLOR='RED',
WHEN=N2 GE 40000,
$
TYPE=SUBTOTAL,
COLUMN=N2,
COLOR=BLUE,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=OFF,
BORDER-RIGHT=LIGHT,
BORDER-COLOR='BLACK',
$
ENDSTYLE
END


Thank you

The way you are doing this it would be the GRANDTOTAL