[agodney]

Hello There
I am using sql*plus to write reports.

I need to have sub totals on various columns as well as a grand totals at the end of the report. This is no problem when the subtotals are on simple columns.

However when the value of column3 is equal to column1 divided by column2 the subtotal and grand total for column3 is incorrect. One cannot simply use the AVG function as it calculates it incorrectly even though the break clause is set on the correct field and the record.

I cannot find any examples of how to do this in my reference books and would be grateful for any assistance.
Thank you for your time. Regards Allan Godney

[joebednarz]

Here's a simple solution:

SELECT column1, amount
FROM <blah>
UNION ALL
SELECT 'Total' as column1, SUM( amount )
FROM <blah>

JoeB

[dbtoo2001]

Read up on rollup, cube and analytics:
http://download-west.oracle.com/docs...tion.htm#83435
http://download-west.oracle.com/docs...1b.htm#2066444
http://tahiti.oracle.com/pls/tahiti/...nalytic#a85397

[agodney]

Thanks for the input, I have had a look at your suggestions, but don't see how it will help me. I have attached a word document that further explains my problem. If you can point me in the right dirrection, I will be grateful. Thanks Allan Godney