JOIN BLANK WITH SALES IN CAR TO BLANK IN FSEQ AS B_
DEFINE FILE CAR
BLANK/A1 WITH SALES=' ';
XCOUNTRY/A10=IF COUNTER EQ 1 THEN 'Grand' ELSE COUNTRY;
XCAR/A16=IF COUNTER EQ 1 THEN ' ' ELSE CAR;
COUNTRYSORT/A1=IF COUNTER EQ 1 THEN 'T' ELSE ' ';
END
TABLE FILE CAR
IF COUNTER LE 2
SUM SALES
BY HIGHEST COUNTRYSORT NOPRINT
SUBTOTAL AS 'Grand' WHEN COUNTRYSORT NE 'T'
BY XCOUNTRY AS COUNTRY
BY XCAR AS CAR
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
March 25, 2009, 06:08 AM
VidyaCA
Hi Shravan,
If this is the solution you are looking for then please have a look at the below code:
SALES SEATS WEIGHT TOTAL 208420 70 45,791 ENGLAND 12000 13 13,876 FRANCE 0 5 2,860 ITALY 30200 10 10,915 JAPAN 78030 8 4,269 W GERMANY 88190 34 13,871 TOTAL 208420 70 45,791
--------------------
TABLE FILE CAR SUM COMPUTE ORDER/I1 = 2; SALES SEATS WEIGHT BY COUNTRY ON TABLE HOLD AS CONTFL FORMAT ALPHA END
TABLE FILE CONTFL SUM COMPUTE ORDER/I1 = 1; COMPUTE COUNTRY/A10 = 'TOTAL'; SALES SEATS WEIGHT ON TABLE HOLD AS TOTFL1 FORMAT ALPHA END
TABLE FILE TOTFL1 SUM COMPUTE ORDER/I1 = 3; COMPUTE COUNTRY/A10 = 'TOTAL'; SALES SEATS WEIGHT ON TABLE HOLD AS TOTFL2 FORMAT ALPHA END
TABLE FILE TOTFL1 PRINT SALES SEATS WEIGHT BY ORDER NOPRINT BY COUNTRY MORE FILE CONTFL MORE FILE TOTFL2 END
WF 764 Windows Excel, HTML, PDF, XML
March 25, 2009, 06:41 AM
Danny-SRL
Vidya,
Your solution entails reading the file 4 times and the use of MORE. I suggest that the use of the McGuyver technique is more economical.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF