I'm attempting to add a 'Total Sum' row of a calculated field to my query result for each 'Sales Rep' I have. I believe I should be using a union to add additional rows, but I would prefer not to have to re-calculate every field again.

This is expected outcome:

```
|SalesRep|Field1|Field2|CalculatedField|
------------------------------------------
|Bob     |value  |value  |12,000         |
|Bob     |value  |value  |3,000          |
|BobTotal|       |       |Sum(Calculated)|
|Tom     |value  |value  |400            |
|Tom     |value  |value  |800            |
|TomTotal|       |       |Sum(Calculated)|

```

So basically, I have this right now:

```
SELECT SalesRep, Field1, Field2, (The Calculated Field)
FROM SalesRepTbl1
union
SELECT SalesRep, Field1, Field2, (The Calculated Field)
FROM SalesRepTbl2

```

This get's me all the data I need, but not the sum of the calculated fields. What is my next step here?

Thank you!