Calculate the value of the following 3 months per month

[caccio88]

Hi everyone,

I learned from the great explanation of gwassenaar here in Calculating rolling n-period totals, averages or other aggregations

how i'm ablet to calculate the value per month of the previous 3 months.

But what if I want to calculate the value per month of the following 3 months?

Someone could help me?

Here attached my example.

Thank u all.

Filiberto

[swuehl]

There shouldn't be a fundamental difference if you want to look ahead in time, maybe just adapt the AsOfMonth Month field calculation (taken from the original doc):

AsOfMonth:
load
Month as Month_AsOf,
Month + (IterNo()-1) as Month
Resident SalesData
while IterNo() <= 3;

[caccio88]

Do u think that it's possible using even the rangesum-aggr combination? swuehl‌

[swuehl · Accepted solution]

Potentially yes, you probably would just need to use below() instead of above() inter record chart function.