I have the following tables
ReportingVersion
| Reporting Date | cobDate |
| 01-Aug-2020 | 01-Jun-2020 |
| 01-Aug-2020 | 01-Jul-2020 |
| 01-Aug-2020 | 01-Aug-2020 |
| 01-Sep-2020 | 01-Jul-2020 |
| 01-Sep-2020 | 01-Aug-2020 |
| 01-Sep-2020 | 01-Sep-2020 |
CobDateDetails
| cobDate | Dept | Status | Amount |
| 01-Jun-2020 | Dept1 | PASS | 1000 |
| 01-Jun-2020 | Dept2 | FAIL | 2000 |
| 01-Jun-2020 | Dept3 | PASS | 1500 |
| 01-Jul-2020 | Dept1 | PASS | 2000 |
| 01-Jul-2020 | Dept2 | PASS | 1000 |
| 01-Jul-2020 | Dept3 | PASS | 2500 |
| 01-Aug-2020 | Dept1 | PASS | 1500 |
| 01-Aug-2020 | Dept2 | FAIL | 2000 |
| 01-Aug-2020 | Dept3 | PASS | 1500 |
| 01-Sep-2020 | Dept1 | PASS | 500 |
| 01-Sep-2020 | Dept2 | FAIL | 700 |
| 01-Sep-2020 | Dept3 | PASS | 1500 |
The user would be making a reporting version selection . Based on the selection i want previous 2 months rolling to be calculated and shown (i.e)
If the user chooses 01-Sep-2020 as the version i want the result to be
| Reporting Date | cobDate | Amount | Comments |
| 01-Sep-2020 | 01-Jul-2020 | 10000 | Should sum Jun + Jul |
| 01-Sep-2020 | 01-Aug-2020 | 10500 | Should Sum Jul + Aug |
| 01-Sep-2020 | 01-Sep-2020 | 7700 | Should sum Aug + Sep |
for 01-Aug-2020 it would be
| Reporting Date | cobDate | Amount | Comments |
| 01-Aug-2020 | 01-Jun-2020 | 4500 | would be only sum june data |
| 01-Aug-2020 | 01-Jul-2020 | 10000 | Should sum Jun + Jul |
| 01-Aug-2020 | 01-Aug-2020 | 10500 | Should Sum Jul + Aug |
Can someone please let me know how to achieve this functionality .
