I have this following example using CAR file. The row-total percentage with across is the sum of the percentage, not the actual percentage. Anyone has any thoughts?
-************************ DEFINE FILE CAR SALESD/D10 = SALES; END -*************************************** TABLE FILE CAR SUM SALESD AS 'Sales' OVER ROW-TOTAL AS 'TOTAL' OVER PCT.SALESD/D6% WITHIN COUNTRY WITHIN SEATS AS '%' BY COUNTRY BY CAR ACROSS SEATS END -***************************** Result: SEATS 2 4 5 TOTAL COUNTRY CAR ENGLAND JAGUAR Sales 0 . 12,000 12,000 % 0% . 100% 100% JENSEN Sales . 0 . 0 % . 0% . 0% TRIUMPH Sales 0 . . 0 % 0% . . 0% FRANCE PEUGEOT Sales . . 0 0 % . . 0% 0% ITALY ALFA ROMEO Sales 25,400 4,800 . 30,200 % 100% 100% . 200% MASERATI Sales 0 . . 0 % 0% . . 0% JAPAN DATSUN Sales . 43,000 . 43,000 % . 55% . 55% TOYOTA Sales . 35,030 . 35,030 % . 45% . 45% W GERMANY AUDI Sales . . 7,800 7,800 % . . 10% 10% BMW Sales . 8,900 71,490 80,390 % . 100% 90% 190%
-********************************************** Result should be: SEATS 2 4 5 TOTAL COUNTRY CAR ENGLAND JAGUAR Sales 0 . 12,000 12,000 % 0% . 100% 100% JENSEN Sales . 0 . 0 % . 0% . 0% TRIUMPH Sales 0 . . 0 % 0% . . 0% FRANCE PEUGEOT Sales . . 0 0 % . . 0% 0% ITALY ALFA ROMEO Sales 25,400 4,800 . 30,200 % 100% 100% . 100% MASERATI Sales 0 . . 0 % 0% . . 0% JAPAN DATSUN Sales . 43,000 . 43,000 % . 55% . 55% TOYOTA Sales . 35,030 . 35,030 % . 45% . 45% W GERMANY AUDI Sales . . 7,800 7,800 % . . 10% 10% BMW Sales . 8,900 71,490 80,390 % . 100% 90% 90%This message has been edited. Last edited by: Kerry,
Shirley Huang WF 7.7.04M MRE BID DevStudio WIN2003, SQL Server 2000/DB2 HTML/PDF/EXL2k/AHTML iSM 6.16
February 27, 2013, 05:20 AM
FrankDutch
DEFINE FILE CAR
SALESD/D10 = SALES;
SALEST/D10 = SALES;
END
-***************************************
TABLE FILE CAR
SUM SALEST NOPRINT
BY COUNTRY
SUM SALESD OVER
-*PCT.SALESD/D7% WITHIN COUNTRY WITHIN SEATS
-*OVER
COMPUTE PCTNEW/D7%=C2/C1*100;
BY COUNTRY
BY CAR
ACROSS SEATS
ON TABLE ROW-TOTAL
ON TABLE NOTOTAL
END
Try this...it is a multiverb solution that might give you the result you need.
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
February 28, 2013, 11:57 AM
Shirley
Thanks! It works!
Shirley Huang WF 7.7.04M MRE BID DevStudio WIN2003, SQL Server 2000/DB2 HTML/PDF/EXL2k/AHTML iSM 6.16