I have the following table and based on the MonthID I want to retrieve the Cumulative Value. ie: For InvoiceID 1 and MonthID 26, I want to add MonthID 24, 25 and 26 reportMonthVal.

**Table**

[![enter image description here](https://i.stack.imgur.com/E01PY.png)](https://i.stack.imgur.com/E01PY.png)

I would like to retrieve the following

**Results**

[![enter image description here](https://i.stack.imgur.com/DMwbn.png)](https://i.stack.imgur.com/DMwbn.png)

Any help or pointing me in the right direction would be much appreciated.