1 Reply Latest reply: Jan 3, 2013 10:52 AM by kart RSS

    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.