WF 8105m

How do I merge my subtotals to span two columns? I also need to put a total in say Row 6 Column E. Here is a car file.

I want to merge column A and B for each Bodytype subtotal and put "Total Bodytype" on same line but in Column E.

 
DEFINE FILE CAR
BOD2/A40 WITH BODY= IF BODYTYPE EQ 'CONVERTIBLE' THEN 'BODY TYPE: CONVERTIBLE' ELSE
                    IF BODYTYPE EQ 'COUPE'       THEN 'BODY TYPE: COUPE'     ELSE
                    IF BODYTYPE EQ 'HARDTOP'     THEN 'BODY TYPE: HARDTOP'     ELSE
					IF BODYTYPE EQ 'ROADSTER'    THEN 'BODY TYPE: ROADSTER'    ELSE
					IF BODYTYPE EQ 'SEDAN'       THEN 'BODY TYPE: SEDAN';
END
TABLE FILE CAR
PRINT   *
ACROSS COUNTRY  
BY BODY
BY BOD2 NOPRINT SUBTOTAL AS ''
ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=SUBTOTAL
     OBJECT=TEXT,
     LINE=1,
	 COLSPAN=2,
$
END 

This message has been edited. Last edited by: FP Mod Chuck,

Thanks JV. How do I upload a file here?

I figured this one out. Here is the updated code.

 DEFINE FILE CAR
SUBTOT/A20   WITH COUNTRY = '*Total Cost';
END
TABLE FILE CAR
PRINT   DEALER_COST RETAIL_COST SALES LENGTH WIDTH HEIGHT WEIGHT WHEELBASE FUEL_CAP BHP RPM MPG ACCEL 
BY  LOWEST COUNTRY
BY  LOWEST CAR
-*BY  MODEL

BY SUBTOT    NOPRINT SUBTOTAL DEALER_COST RETAIL_COST  AS ''
BY MODEL      
BY BODYTYPE   
BY SEATS      
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
-*ON TABLE PCHOLD FORMAT EXL07
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=SUBTOTAL,
     BY=3,
     COLOR='RED',
	 JUSTIFY=RIGHT,
$
ENDSTYLE
END