Given this simple example, is it possible to not show the detail (a sum) for CARCOUNT, but show the Total of CARCOUNT by COUNTRY or would this report have to be written a different way. This report is fine for all the other iterations I am doing, but for one particular request showing this information at a "detail" (sum) level will cause confusion.

  
DEFINE FILE CAR 
CARCOUNT/I5 = 1;
END
TABLE FILE CAR
SUM CARCOUNT
    SEATS
    DEALER_COST
	COMPUTE CostPerSeat/I6 = ( DEALER_COST / SEATS );
BY  COUNTRY RECOMPUTE
BY  MODEL 
END

OUTPUT FROM ABOVE

COUNTRY MODEL 		CARCOUNT SEATS DEALER_COST 	CostPerSeat 
ENGLAND INTERCEPTOR III 1 	 4	 14,940		 3735 
	TR7 		1 	 2 	  4,292 	 2146 
 	V12XKE AUTO 	1 	 2 	  7,427 	 3713 
	XJ12L AUTO 	1 	 5 	 11,194 	 2238 
*TOTAL ENGLAND 		4 	13 	 37,853		 2911 
FRANCE 504 4 DOOR 	1 	 5 	  4,631		  926 
*TOTAL FRANCE		1	 5	  4,631 	  926 

-------------------------------------------------------------------
How we would like it to look

COUNTRY MODEL 		CARCOUNT SEATS DEALER_COST 	CostPerSeat 
ENGLAND INTERCEPTOR III   	 4	 14,940		 3735 
	TR7 		  	 2 	  4,292 	 2146 
 	V12XKE AUTO 	 	 2 	  7,427 	 3713 
	XJ12L AUTO 	  	 5 	 11,194 	 2238 
*TOTAL ENGLAND 		4 	13 	 37,853		 2911 
FRANCE 504 4 DOOR 	 	 5 	  4,631		  926 
*TOTAL FRANCE		1	 5	  4,631 	  926 

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

A little trick:

  
DEFINE FILE CAR 
CARCOUNT/I5 = 1;
END
TABLE FILE CAR
SUM CARCOUNT
    SEATS
    DEALER_COST
	COMPUTE CostPerSeat/I6 = ( DEALER_COST / SEATS );
BY  COUNTRY RECOMPUTE
BY  MODEL 
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=CARCOUNT, COLOR=WHITE, $
ENDSTYLE
END

Thanks Daniel. Much appreciated. That worked fine.