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

[stephenedberkg]

Dear susovan.g ,

share this expression. i am using personal edition.

[susovan]

Hi Friends,

Try this script and use Sr.no as a dimension in list box.

LOAD *,

RowNo() as Sr.no;

LOAD * INLINE [

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,

];

[ajsjoshua]

Hi,

Thats not my requirement find the sample attached.

[susovan]

Hi Joshua,

PFA

[ajsjoshua]

Hi,

I am using personal edition brother pls share the expression.

[susovan]

Hi,

I do not use any calculated expression for the "Order".

[ajsjoshua]

Hi susovan.g

The forecasted orders should be calculated whenever the user selects a week from the calendar(upload week).