Hello
in report when I run this month which shows last 5 months data from Jan to may , next month when I run the workflow it should show last 5 months data but the last fifth month column will be sum of feb+ jan month values, similarly I July when I'm running it should show last fifth month column will be sum of Feb+March+Jan remaining will be same as last 4 months from the current month . fifth month column calculation with previous month starts on MAY and reset on next year May.
sample o/p in current month
| Group | Jan (2022) | Feb(2022) | March(2022) | April(2022) | May(2022) |
| data1 | 1 | 1 | 1 | 1 | 1 |
| data2 | 1 | 1 | 1 | 1 | 1 |
| data3 | 1 | 1 | 1 | 1 | 1 |
| data3 | 1 | 1 | 1 | 1 | 1 |
| data4 | 1 | 1 | 1 | 1 | 1 |
sample o/p when run it on next month
| Group | Jan - Feb (2022) | March | April | May | June |
| Data1 | 2 | 1 | 1 | 1 | 1 |
| Data2 | 2 | 1 | 1 | 1 | 1 |
| Data3 | 2 | 1 | 1 | 1 | 1 |
| Data4 | 2 | 1 | 1 | 1 | 1 |
