This is what my table looks like:

| RefNum | Year | CorrespVNum | Proceeds | BaseCost |
| --- | --- | --- | --- | --- |
| 12345 | 2019 | 54321 | 12345.69 | 10000.00 |
| 12345 | 2019 | 54321 | 500.69 | 6000.00 |
| 12345 | 2019 | 65432 | 12345.69 | 10000.00 |
| 12345 | 2019 | 65432 | 500.69 | 6000.00 |
| 23456 | 2020 | 33344 | 50000.00 | 15000.00 |
| 34567 | 2021 | 11155 | 521.00 | 1000.00 |
| 34567 | 2021 | 11155 | 17.00 | 800.00 |
| 34567 | 2021 | 11155 | 85.00 | 100.00 |

I want the result to look like this:

| RefNum | Year | CorrespVNum | TotalProceeds | TotalBaseCost |
| --- | --- | --- | --- | --- |
| 12345 | 2019 | 54321 | 12846.38 | 16000.00 |
| 12345 | 2019 | 65432 | 12846.38 | 16000.00 |
| 23456 | 2020 | 33344 | 50000.00 | 15000.00 |
| 34567 | 2021 | 11155 | 623.00 | 1900.00 |

So the matching criteria are the Refnum, Year and CorrespVnum. I have been messing around with a CTE query and I can't seem to get it to work. It works if I only have 2 matching rows but if there are more than 2 then it doesn't work.

Does anyone have any idea how to do this?