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,
WebFOCUS 8105m Windows, All Outputs
January 24, 2018, 05:46 PM
Jveselka
Thanks JV. How do I upload a file here?
WebFOCUS 8105m Windows, All Outputs
January 26, 2018, 08:32 AM
Jveselka
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