One option might be to utilise WITH CUBE or WITH ROLLUP and the Grouping() function

Per BOL;

Grouping is an aggregate function that causes an additional column to be output with a value...