Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 3, 2013 10:52 AM by
Customised sub-total via UNION query - how to exclude from totals?
Jan 3, 2013 9:56 AM
I have a client requirement that a couple of companies have their own sub-total in a report, a treatment which applies to no other companies in their group.
I have achieved this via a union all, but they also want a total of companies.
Is there anyway to emulate a Grand Total, other than another union query such that the double count is not double counted?
thanks for any ideas.
This content has been marked as final.
Show 1 reply
Re: Customised sub-total via UNION query - how to exclude from totals?
Jan 3, 2013 10:52 AM
in response to
only solution which i can think of is to create another union request for the grand total.. this way you wont add up your sub totals twice..