I'm trying to obtain a percent to total off of each sum field. I have a row-total sum and need the percentages for each sum. Any samples out there. Thanks for any assistance possible!

 TABLE FILE SQLOUT
SUM 
     Option1
     HangUp
     Option2
     Option3
     TimeOut
     Operator
BY Market
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE ROW-TOTAL AS 'TOTAL'
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON

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

Joe,

If you will do a search on - Percent Row
You will get many examples.

What I'm looking for is percent to totals:

Example:

opt1 opt2 opt3 total
east 500 400 600 1500
33% 27% 40% 100%
west 300 300 200 800
38% 38% 25% 100%
Grand Tot 800 700 800 2300
35% 30% 35% 100%


Thanks!

Look up RECOMPUTE and SUMMARIZE