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,

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.

Thanks! It works!