For WF 8 the accordion HTML report can display Column Total row with commands
ON TABLE SET EXPANDBYROW ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML

However, the WF 7.7.03 has bug, it can’t display the grand column total. I need to deliver a report with the grand total for each column, but we are not ready for WF 8 upgrade. Is there a workaround way to display Grand total row?

In the following sample, I need a grand row which show DEALER_COST and SALES of all COUNTRIES combined. thanks.

  
TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST
     CAR.BODY.SALES
BY  LOWEST CAR.ORIGIN.COUNTRY
BY  LOWEST CAR.COMP.CAR
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE SET EXPANDBYROW ON 
ON TABLE SUMMARIZE CAR.BODY.DEALER_COST CAR.BODY.SALES AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END

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

I haven't been able to placed the Total at the end due to the nature of BY EXPANDBYROW, but this may answer your need:

TABLE FILE CAR
SUM DEALER_COST
    SALES
BY TOTAL COMPUTE ID/A6 = 'TOTAL';
BY COUNTRY
BY CAR
ON TABLE HOLD AS HLDDET FORMAT FOCUS
END
-RUN

TABLE FILE HLDDET
SUM DEALER_COST
    SALES
BY ID AS ''
BY COUNTRY
BY CAR
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE SET EXPANDBYROW ON 
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
-RUN