Hi All,
I have a Table as below

PRODUCT AMOUNT
ASDF 1000

FRGH 2000

MNJI 3000


Total for all Products (ASDF +FRGH +MNJI) is 6000

Now i need to display as below

PRODUCT AMOUNT TOTAL
ASDF 1000 6000

FRGH 2000 6000

MNJI 3000 6000


Could you please suggest us how to reach this requirement.

Thanks,
Raghu

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

Something like this perhaps:

TABLE FILE CAR
SUM SALES NOPRINT
SUM SALES
    COMPUTE TOTALSALES/I8 = C1;
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE SUBTOTAL SALES AS 'TOTAL'
END

Hope this helps ...

Or

TABLE FILE CAR
SUM SALES
COMPUTE TOTALSALES/I8 = TOT.SALES;
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE SUBTOTAL SALES AS 'TOTAL'
END