Forecast, Calender

[William2]

Dear community, 

I am struggeling with a problem for a few month now. There are several posts that are kind of similuar but there is still something missing. 

I have the current Stock value for the current month(e.g. june) in table stock. 

I would like to create a calender or table for the next 36 month, the value for every month should be the current sum(stock value) like e.g. 

Monthname(date); sum(stock value)

June/2021;100€

July/2021;100€

August/2021;100€

September/2021;100€

So on for next 36 month

In a Chart i would do this with total but i would like to create this in load Statement to create a canonical calender to join several calender dates like Orders to create a forecast. 

This is just a part of my hole problem but find a solution for this part would help me a lot. 

Thanks for every hint and sorry for this really bad discription of my situation.

[Sammy_AK]

try this

Monthname(date); sum(total stock value)

[William2 · Accepted solution]

Hello Sammy, 

Thanks for Replying. As feared my question was not clear but i guess I solved it by my own. I try on monday to implement it. The solution should look like this. 

Stock:

Load

IterNo()

Item 

Quantity 

Monthname(AddMonth(today(0),IterNo()-1))

From somefile.xlsx 

While IterNo() <= 36; 

I Know there are a lot of syntax errors but the concept should work. 

This was a really bad first question to join the community but thanks anyway. 

Best regards 

Will