Hi -

Consider the following...

  
TABLE FILE GGSALES
SUM 
     DOLLARS AS ' '
BY CATEGORY
BY REGION
BY ST
BY TOTAL DOLLARS AS 'Sales,By State'
ACROSS HIGHEST DATE
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE SUMMARIZE AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
ENDSTYLE
END

How can I get a Grand Total of the column indicated as BY TOTAL DOLLARS AS 'Sales,By State'?

Thanks!

Dan

This message has been edited. Last edited by: Dan Pinault,

Sort fields are not summarized, so you need to make the displayed column a verb object rather than a sort field.

Use multiple SUM verbs, to report at multiple levels of detail:

  TABLE FILE GGSALES
SUM 
     DOLLARS AS 'Sales,By State'
BY CATEGORY
BY REGION
BY ST

SUM 
     DOLLARS AS ' '
BY CATEGORY
BY REGION
BY ST
ACROSS HIGHEST DATE

 . . .

END

(With a single verb, in priciple WITHIN ST can accomplish the same thing -- but I am not sure how WITHIN and ACROSS interact.)

Excellent! Thanks j.gross for the solution.

Dan