SELECT region, value
FROM YourData
UNION ALL
SELECT 'Grand Total' AS [region], SUM(value) AS [value]
FROM YourData
GROUP BY 'Grand Total'
Excel Workbook | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Name | QTY A | QTY B | Grand Total | |||||||||
2 | Bill | 60 | 75 | 134 | |||||||||
3 | Suzy | 71 | 78 | 149 | |||||||||
4 | Jill | 55 | 77 | 132 | |||||||||
5 | Will | 61 | 85 | 145 | Values | ||||||||
6 | Joe | 69 | 96 | 165 | Row Labels | Sum of QTY A | Sum of QTY B | Sum of Grand Total | |||||
7 | Jane | 83 | 94 | 177 | Bill | 59.5777601 | 74.86379743 | 134.4415575 | |||||
8 | Jane | 82.86074698 | 93.76605749 | 176.6268045 | |||||||||
9 | Jill | 55.30354679 | 76.71231627 | 132.0158631 | |||||||||
10 | Joe | 69.29734647 | 95.82710862 | 165.1244551 | |||||||||
11 | Suzy | 71.1168915 | 77.89899111 | 149.0158826 | |||||||||
12 | Will | 60.99369824 | 84.50148106 | 145.4951793 | |||||||||
13 | Grand Total | 399.1499901 | 503.569752 | 902.7197421 | |||||||||
14 | |||||||||||||
Sheet1 |