Let's say I have a recompute row like this:

ON SORT_FIELD
RECOMPUTE AS 'Sub Total'
...

Now I need to format the text 'Sub Total', I tried this

TYPE=SUBTOTAL, BY=SORT_FIELD, ITEM=1,

or

TYPE=SUBTOTAL, BY=SORT_FIELD, COLUMN=N1,

none of these work. Can't find it in the documentation either.

Any idea?

This message has been edited. Last edited by: <Kathryn Henning>,

It appears this works - specify the subtotal column name, you can't style only the text, but you can style the text and the value:

TABLE FILE CAR
SUM
SALES
WHEELBASE
BY COUNTRY
BY CAR

ON COUNTRY SUBTOTAL AS 'TOTAL COUNTRY -'

ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, FONT='ARIAL', SIZE=9, BORDER=1, BORDER-COLOR=SILVER, $
TYPE=SUBTOTAL, COLUMN=COUNTRY, COLOR=BLUE, $

ENDSTYLE
END

Thank you Francis!

It happens that the client wants to have normal style in the data column, bold for "Sub Total" text, and "Sub Total" has a different justification than the actual total numbers.

I may have to use SUBFOOT "

Francis,

Nice.