If you run this code all the percentages get calculated and recalculated correctly except for the per cent total at the total country level. (percent to total = 2/18 and percent to country = 2/4 for example for the Jaguar.) You can see total count gets to be zero at the 'Total Country England' level. The percentage should be recalculated as 4/18 = 22.2%. Any ideas on how to do that are appreciated.

TABLE FILE CAR
SUM CNT.BODYTYPE
SUM
CNT.BODYTYPE
BY COUNTRY
SUM
CNT.BODYTYPE
BY COUNTRY
BY CAR
SUM
COMPUTE C1/D12 = C1; AS 'TOTAL'
COMPUTE C2/D12 = C2; AS 'TOTCNTRY'
COMPUTE C3/D12 = C3; AS 'TOTCAR'
COMPUTE PCT_TOTAL/D12.2% = C3/C1 * 100;
COMPUTE PCT_CNTRY/D12.2% = C3/C2 * 100;
BY COUNTRY
BY CAR SUMMARIZE MULTILINES
END

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

use recompute not summarize

With MULTILINES there is no summary by Country, without I get a summary line per car but all 0%

Hi Rick,

You may want to try the following code:

TABLE FILE CAR
SUM 
CNT.BODYTYPE WITHIN TABLE    NOPRINT
CNT.BODYTYPE WITHIN COUNTRY  NOPRINT  
CNT.BODYTYPE WITHIN CAR      NOPRINT
CNT.COUNTRY WITHIN CAR       NOPRINT
COMPUTE TOT1/D12 = C1/C4; AS 'TOTAL '
COMPUTE TOT2/D12 = C2/C4; AS 'TOTCNTRY '
COMPUTE TOT3/D12 = C3/C4; AS 'TOTCAR '
COMPUTE PCT_TOTAL/D12.2% = TOT2/TOT1 * 100;
COMPUTE PCT_CNTRY/D12.2% = TOT3/TOT2 * 100;
BY COUNTRY  
BY CAR SUMMARIZE MULTILINES
ON TABLE SET STYLE *
GRID=OFF,$
END 

Cheers,

Kerry