1 Reply Latest reply on Jan 3, 2013 4:52 PM by kart

    Customised sub-total via UNION query - how to exclude from totals?

    Robert Angel

      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.