Hi,
I have a report in which I want to find average and then total for each column which is grouped by first column. I used
ON COL1 SUBTOTAL AVE. COL2 AVE. COL3...
ON COL1 SUBTOTAL COL2 COL3....

But in the ouput it is not showing the total although it is showing average for each group.
Can anyone suggest anything for the same?

Thanks
Deepa

It's a tric

DEFINE FILE MOVIES
NRATING/A10=RATING;
END
TABLE FILE MOVIES
PRINT
     COPIES
     LISTPR
     WHOLESALEPR
     DIRECTOR
BY NRATING NOPRINT
BY RATING
BY CATEGORY

ON RATING SUBTOTAL
     SUM. LISTPR AS 'SUM'
ON NRATING SUBTOTAL
     AVE. LISTPR
     AVE. WHOLESALEPR AS 'AVE'
END

I created a dummy by field that's in fact the same as the original and now you can add an aextra line with the average values.