Hi,
I've the below.
Rolling:
Load * Inline [
Fiscal Period,Sales
202211,600
202212,550
202301,100
202302,200
202303,300
202304,400
202305,500
202306,600
202307,700
202308,800
202309,900
202310,1000
202311,1100
202312,1200
202401,1300
202402,1400
];
I'm looking for script in the backend to calculate the 12 Month number, expecting output as below.
| Fiscal Period |
Sales |
12M Rolling Sales |
| 202211 |
- |
- |
| 202212 |
- |
- |
| 202301 |
100 |
100 |
| 202302 |
200 |
300 |
| 202303 |
300 |
600 |
| 202304 |
400 |
1000 |
| 202305 |
500 |
1500 |
| 202306 |
600 |
2100 |
| 202307 |
700 |
2800 |
| 202308 |
800 |
3600 |
| 202309 |
900 |
4500 |
| 202310 |
1000 |
5500 |
| 202311 |
1100 |
6600 |
| 202312 |
1200 |
7800 |
| 202401 |
1300 |
9100 |
| 202402 |
1400 |
10400 |
I can achieve it in the front end by using RangeSum + above, but I want it to be implemented in the backend script so that I can store the 12 Month Rolling numbers in QVD and use the QVD in other app.
Regards,
V
