Is there anyway to make a RECOMPUTE do averages?

TABLE FILE CAR
BY COUNTRY
BY CAR NOPRINT
SUM CAR AVE.SEATS SEATS SALES
ON COUNTRY RECOMPUTE MULTILINES AS 'Total'
ON COUNTRY SUBFOOT
" "
END

I would really like RECOMPUTE to average the AVE.SEATS. Thanks!

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

Try calculating your own average with a COMPUTE statement - then the RECOMPUTE should work:

TABLE FILE CAR
SUM 
CAR 
AVE.SEATS

COMPUTE AVESEATS/I4 = SEATS / CNT.SEATS;

SEATS 
SALES

BY COUNTRY
BY CAR NOPRINT

ON COUNTRY RECOMPUTE MULTILINES AS 'TOTAL'

ON COUNTRY SUBFOOT
" "
END

Thanks Francis! You're a lifesaver.