I need to calculate the total for a group, and have it show on the detail line and use it in some calculations for the detail line.

TABLE FILE ACCTTRANSACTION
PRINT
ATSELLAMT/P12.2M AS 'SELL AMT'

BY ATSTOREDIVNO AS 'DIV'
BY ATALTSTOREID AS 'STORE'
BY ATDOCUMENTNO AS 'INVOICE'
BY ATTRANSDATE AS 'TRAN DATE'
ON ATALTSTOREID SUBTOTAL AS '*TOTAL'

I need the total purchased by a given store to show on the detail line, and then use that to determine a rebate percent based on total purchases for the store.

How can I calculate store total and use it in my report?

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

a multi-verb request should do the trick:

TABLE FILE CAR
SUM 
COMPUTE TSALES/D10 = SALES; NOPRINT
BY COUNTRY
PRINT 
TSALES
SALES/D10
COMPUTE SALES_PCT/D10.2 = SALES / TSALES * 100;
BY COUNTRY
BY CAR
END 

Thanks...that is what I needed!!!!!!