@Alan Fitch Take a look at Oracle's ROLLUP extension. It looks something like this:

SELECT
	BUILTIN.DF( Status ) AS StatusName,
	COUNT( * ) AS TransactionCount,
	SUM( ForeignTotal ) AS TotalAmount
FROM 
	Transaction 
WHERE 
	( Type = 'SalesOrd' )
GROUP BY
	ROLLUP( BUILTIN.DF( Status ) )

The result is a summary row appended to the result set, and looks like this.