I would like to get pct of total like this

group amt PCT
A $50 50%
A $50 50%
TOTAL A $100 100%
B $25 25%
B $75 75%
TOTAL B $100 100%

When I do this

TABLE FILE filename
SUM
AMT
PCT.AMT/D20.4 AS 'AMT'
BY GROUP

I get

group amt PCT
A $50 25%
A $50 25.6%
TOTAL A $100 50%
B $25 12.5%
B $75 37.5%
TOTAL B $100 50%

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

Jammer,

If you have

  
group    amt PCT
A        $50 25%
A        $50 25.6%
TOTAL A $100 50%
B        $25 12.5%
B        $75 37.5%
TOTAL B $100 50%

then, you are sorting on more than group.

Now if you want 100% for each group then you have to use the WITHIN clause with PCT:

  
TABLE FILE filename
SUM
AMT
PCT.AMT/D20.4 AS 'AMT' WITHIN GROUP
BY GROUP

Thanks - that was easy - I just could not find it!