Hi Everyone

Maybe one of your guys can help me a little bit.

I have the following report:

TABLE FILE CAR
SUM
CAR.SPECS.LENGTH
COMPUTE PRCT/D12.2% = CAR.SPECS.LENGTH/100;
BY CAR.COMP.CAR
BY LOWEST CAR.BODY.SALES
ACROSS LOWEST CAR.SPECS.RPM
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

I need to include the "SALES" column also in the total "table column-total" row, so the total "SALES" amount appears on the same line as the column totals of the across fields. I studied the manual for ages, but couldn't find a proper solution for this.

Many thanks for you help and time!

Best regards
Matt

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

I think you'll need a multi-verb request. Try something like this.

TABLE FILE CAR
SUM SALES
BY CAR
SUM
LENGTH
COMPUTE PRCT/D12.2% =LENGTH/100;
BY CAR
ACROSS LOWEST CAR.SPECS.RPM
ON TABLE COLUMN-TOTAL AS 'TOTAL:'
END

Hi BabakNYC

I had once such a solution, but I forgot to add the "BY" statement in the first SUM section.

Many, many thanks for your great help. It works like a charm.

Best regards
Matt