I am trying to get subtotals for two classes of ASSETs, BA and OTHER. With the following code I display a final grand total. I�d like to add two lines at the bottom of the report detailing the total BA asset amount and the total OTHER asset amount.

SUM PARVALUE AS 'AMOUNT'
BY GROUPING AS 'COMPANY,GROUP'
BY ASSET AS 'ASSET,TYPE'
BY MATURITY AS 'MAT'
BY ISSUERU AS 'ISSUER'
BY SECOND_DESC AS 'ISSUE'
BY PORT AS 'PORT'
ON GROUPING SUBTOTAL MULTILINES
ON ASSET SUBTOTAL MULTILINES
ON ASSET SKIP-LINE
ON TABLE SET ONLINE-FMT EXL2K

My report must be sorted as the code describes, ie not displaying all BA asset holdings together above all OTHER asset holdings. I can get asset totals that way, but the report must keep the GROUPINGS intact.

Any ideas on what code will give me a breakdown of the grand total by BA and OTHER asset holdings would be appreciated.

Thanks, vickie

What you may be able to do is create 2 compute field 1 for BA and 1 for other and id ASSET is BA then in the BA one say

BAASSET/??? = IF ASSET EQ 'BA' THEN PARVALUE ELSE LAST BAASSET; NOPRINT

OTHERASSET/??? IF ASSET NE 'BA' THEN PARVALUE ELSE LAST OTHERASSET; NOPRINT

THEN

ON TABLE SUBFOOT
" TOTAL BA ASSET = <BAASSET"
" TOTAL OTHER ASSES = <OTHERASSES"

Hope This Helps

Another option using the car file:


DEFINE FILE CAR
SAL1/D12=IF COUNTRY EQ 'ENGLAND' THEN SALES ELSE 0;
SAL2/D12=IF COUNTRY NE 'ENGLAND' THEN SALES ELSE 0;
END
TABLE FILE CAR
SUM SALES SAL1 NOPRINT SAL2 NOPRINT
BY COUNTRY
ON TABLE COLUMN-TOTAL
ON TABLE SUBFOOT
"TOTAL ENGLAND <TOT.SAL1"
"TOTAL OTHERS <TOT.SAL2"
END


COUNTRY SALES
------- -----
ENGLAND 12000
FRANCE 0
ITALY 30200
JAPAN 78030
W GERMANY 88190

TOTAL 208420
TOTAL ENGLAND 12,000
TOTAL OTHERS 196,420

Thank you! I hadn't considered using subfoot. Appreciate your quick responses.

vickie