Row Total Label
Request to be able to provide a label that says "total" for the totals row. While you might think this is a one-off, I don't know of any financial, or other metric report that an executive or manager has ever asked for in any job I've worked where they didn't want to show a label indicating total or subtotal. Invoices also will usually have subtotal row headers and grand total row headers. I like the UNION idea as I do this natively in SQL and Crystal Reports all the time. But it gets sticky as soon as you want to do a UNION on top of a report that already have 2 append subqueries.