TABLE FILE CAR

SUM 
CAR.BODY.SALES NOPRINT
BY CAR.ORIGIN.COUNTRY

SUM 
CAR.BODY.SEATS
BY CAR.ORIGIN.COUNTRY
ACROSS LOWEST CAR.COMP.CAR ACROSS-TOTAL
RECAP TOTSALES/D15 = C1 ;
-* C1 refers to the sales of first SUM verb.

ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty, $
END

quote:

I have added a column-total by in some cases I do not want the RECAP columns (in this case seats) not to be calculated

TABLE FILE CAR
SUM
CAR.BODY.SALES NOPRINT
BY CAR.ORIGIN.COUNTRY
SUM
CAR.BODY.SEATS
BY CAR.ORIGIN.COUNTRY
ACROSS LOWEST CAR.COMP.CAR ACROSS-TOTAL
RECAP TOTSALES/D15 = C1 ;

-* 1. Summarize all
-* ON TABLE SUMMARIZE AS 'Total'
-* Summarize SEATS AND Recap TOTSALES
-* ON TABLE SUMMARIZE SEATS C3 AS 'Total'

-* 2. Summarize only Seats
-* ON TABLE SUMMARIZE SEATS AS 'Total' 

-* 3. Summarize only Recap TOTSALES
ON TABLE SUMMARIZE C3 AS 'Total' 

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,$
END

quote:

Sorry to ask but how can I do the code-tag?

</>