So, for the output, I want the first column to be dates for June. and then taking the last day for May (31May2020 900 orders), multiplying 900 with 13% (percent from day 1 ) , I get 115 for 01June2020, multiplying 900 with 12%(percent from day 2), I get 111 (for 02June2020) and continuing this way for 900 until 30June2020. Similarly, I want to do this calculation for the Orders number from 30May2020 which is 800 and split it based on percents from Day1-30 for June 02-June30.
Continuing this way for the last 10 orders from May.
The last column below is just the sum of the row for each date from 01June-30June.
The first column (dates) and the last column (Finished Orders) are my desired output.
Finished Orders
01Jun2020
115
115
02Jun2020
111
102
212
03Jun2020
104
98
89
291
04Jun2020
84
92
86
76
338
05Jun2020
74
75
81
74
64
367
06Jun2020
64
66
65
69
61
51
377
07Jun2020
50
57
58
56
58
49
38
366
08Jun2020
39
45
50
49
47
46
37
25
338
09Jun2020
43
35
39
43
41
37
35
25
13
310
10Jun2020
26
38
30
33
36
33
28
23
12
45
304
11Jun2020
20
23
34
26
28
29
25
19
12
43
257
12Jun2020
16
18
20
29
22
22
21
16
9
40
214
13Jun2020
16
14
16
17
24
17
17
14
8
33
175
14Jun2020
13
14
12
13
14
19
13
11
7
29
146
15Jun2020
12
12
12
10
11
11
14
9
6
25
123
16Jun2020
9
11
10
10
9
9
9
10
4
20
100
17Jun2020
10
8
10
9
9
7
7
6
5
15
84
18Jun2020
6
8
7
8
7
7
5
4
3
17
74
19Jun2020
8
5
7
6
7
6
5
3
2
10
61
20Jun2020
5
7
5
6
5
6
4
3
2
8
52
21Jun2020
6
5
6
4
5
4
4
3
2
6
45
22Jun2020
7
5
4
5
3
4
3
3
1
6
42
23Jun2020
6
6
4
4
4
3
3
2
1
5
38
24Jun2020
9
5
5
4
3
4
2
2
1
5
39
25Jun2020
3
8
4
4
3
2
3
1
1
4
34
26Jun2020
4
3
7
4
4
2
2
2
1
4
32
27Jun2020
4
4
2
6
3
3
2
1
1
2
29
28Jun2020
4
4
3
2
5
3
2
1
1
3
27
29Jun2020
5
3
3
3
2
4
2
1
1
2
26
30Jun2020
5
5
3
3
2
1
3
1
1
2
26
... View more
