Forecasted orders

[ajsjoshua]

Hi all,

I have two dates Upload week and forecast week ,i am using upload week in my calendar.

If user select uploadweek=2,it should display orders for uploadweek=1 and forecastweek=2

my answer should be 13

UploadWeek	ForecastWeek	orders
1	1	12
1	2	13
1	3	12
1	4	11
1	5	44
1	6	32
1	7	72
1	8	43
1	9	26
1	10	66
1	11	12
1	12	43
2	1	54
2	2	32
2	3	76
2	4	54
2	5	32
2	6	42
2	7	53
2	8	45
2	9	23
2	10	23
2	11	12
2	12	23

[MindaugasBacius]

What is the logic?

If I select uploadweek = 1, why forecastweek = 2 not 3 or 10?

[ajsjoshua]

Hi mindaugasbacius

Actually in every upload week we forecast orders for next 12 weeks.

Now i want to find what is forecasted orders for week 2.

[MindaugasBacius]

Well, I guess than you should leave only rows with Forecast = 2 in your loading stage:

Where Forecast = 2;

In case you elaborate more details the other options may appear.

[sujeetsingh]

Can you come in more words or provide a sample

[ajsjoshua]

Hi  mindaugasbaciussujeetsingh

PFA

[Digvijay_Singh]

May be like this

[ajsjoshua]

Hi,

digvijay

i want to show this dynamically

pls see the sample app.

[susovan]

Hi johua,

Try this attachment,

[ajsjoshua]

Hi susovan.g

I am using personal edition

pls share expression