In the below query I am taking a count on distinct cars for countries. Need to take count at subtotal and grand Total as well.
Please find below the query for same

TABLE FILE CAR
SUM
COMPUTE CNT/I3= CNT.CAR; NOPRINT
BY COUNTRY
PRINT
CAR
MODEL
RETAIL_COST
DEALER_COST
BY COUNTRY
ON COUNTRY SUBTOTAL
RECAP SUBCNT/I3 = CNT.CAR;
ON TABLE COLUMN-TOTAL AS 'GRAND TOTAL'
RECAP TOTCNT/I3=CNT.CAR;
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM OFF
END

I am able to get the count at subtotal and grand total level as well but the recap field SUBCNT should be displayed as 'Subtotal Car Count' and TOTCNT should be displayed as 'Total Car Count' on the report.
How do i get this done? Please help.

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

How about this

 TABLE FILE CAR
SUM 
COMPUTE CNT/I3 = CNT.CAR; NOPRINT
 
BY COUNTRY
PRINT
CAR
MODEL
RETAIL_COST
DEALER_COST
BY COUNTRY
ON COUNTRY SUBTOTAL
ON COUNTRY SUBFOOT
" Subtotal Car Count <ST.CNT"
   
ON TABLE COLUMN-TOTAL AS 'GRAND TOTAL'
ON TABLE SUBFOOT 
"Total Car Count <ST.CNT"
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET PAGE-NUM OFF
END

 

quote:

RECAP TOTCNT/I3=CNT.CAR;

This is a possibility also ... I have used this in the past on other COMPUTE fields.

Try it on the RECAP ...

 
RECAP 'Total Car Count'/I3=CNT.CAR;