Hi All,

In the below code when I do a row-total it gives me a total of both DEALER_COST and RETAIL_COST. I need only the DEALER_COST ROWTOTAL to be displayed and not the retail cost.
Could anyone please help me with this.

TABLE FILE CAR
PRINT
DEALER_COST
BODYTYPE
RETAIL_COST ROW-TOTAL
ACROSS COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
SIZE=9,
STYLE=BOLD,
$
ENDSTYLE
END

Thanks

This message has been edited. Last edited by: Kerry,

Multiverb is the solution

DEFINE FILE CAR
TOTRETAIL=RETAIL_COST;
END
TABLE FILE CAR
SUM TOTRETAIL
BY BODYTYPE
BY CAR
BY MODEL
PRINT
DEALER_COST 
RETAIL_COST 
BY BODYTYPE
BY CAR
BY MODEL
ACROSS COUNTRY
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
END

now you get the rowtotal of the retail_cost at the beginning.

If you add the following to Frank's code, TOTRETAIL becomes the last column.

SEQUENCE sets column order. Documentation: Creating Reports With WebFOCUS Language > Laying Out the Report Page > Arranging Columns on a Page.

ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=TOTRETAIL, SEQUENCE=100, $
ENDSTYLE

That's Great Francis,

That put's the total at the end, where one may expect it to be...

Thanks a lot Frank and Francis!