Aggretated by day over previous 30

	A	B	C	D	F	G
1	date	retail_leads	(Need this) Total over Previous 30 Days
2	16-Jan-20	42			8/1/2018	7/2/2018
3	17-Jan-20	49
4	18-Jan-20	31
5	19-Jan-20	32
6	20-Jan-20	44
7	21-Jan-20	44
8	22-Jan-20	42
9	23-Jan-20	47
10	24-Jan-20	31
11	25-Jan-20	19
12	26-Jan-20	17
13	27-Jan-20	30
14	28-Jan-20	27
15	29-Jan-20	30
16	30-Jan-20	15
17	31-Jan-20	16
18	1-Feb-20	11
19	2-Feb-20	17
20	3-Feb-20	35
21	4-Feb-20	24
22	5-Feb-20	23
23	6-Feb-20	25
24	7-Feb-20	28
25	8-Feb-20	40
26	9-Feb-20	48
27	10-Feb-20	67
28	11-Feb-20	50
29	12-Feb-20	35
30	13-Feb-20	59
31	14-Feb-20	45	1023	<--Total Retail leads from 16-Jan-20 and 14-Feb-20
32	15-Feb-20	33	1014	<--Total Retail leads from 17-Jan-20 and 15-Feb-20
33	16-Feb-20	44	1009	<--Total Retail leads from 18-Jan-20 and 16-Feb-20
34	17-Feb-20	50	1028	<--Total Retail leads from 19-Jan-20 and 17-Feb-20
35	18-Feb-20	40	1036	<--Total Retail leads from 20-Jan-20 and 18-Feb-20
36	19-Feb-20	39	1031	<--Total Retail leads from 21-Jan-20 and 19-Feb-20
37	20-Feb-20	45	1032	<--Total Retail leads from 22-Jan-20 and 20-Feb-20
38	21-Feb-20	30	1020	<--Total Retail leads from 23-Jan-20 and 21-Feb-20
39	22-Feb-20	20	993	<--Total Retail leads from 24-Jan-20 and 22-Feb-20
40	23-Feb-20	21	983	<--Total Retail leads from 25-Jan-20 and 23-Feb-20
41	24-Feb-20	22	986	<--Total Retail leads from 26-Jan-20 and 24-Feb-20
42	25-Feb-20	12	981	<--Total Retail leads from 27-Jan-20 and 25-Feb-20
43	26-Feb-20	23	974	<--Total Retail leads from 28-Jan-20 and 26-Feb-20
44	27-Feb-20	22	969	<--Total Retail leads from 29-Jan-20 and 27-Feb-20
45	28-Feb-20	43	982	<--Total Retail leads from 30-Jan-20 and 28-Feb-20
46	29-Feb-20	12	979	<--Total Retail leads from 31-Jan-20 and 29-Feb-20
47	1-Mar-20	13	976	<--Total Retail leads from 1-Feb-20 and 1-Mar-20
48	2-Mar-20	19	984	<--Total Retail leads from 2-Feb-20 and 2-Mar-20
49	3-Mar-20	25	992	<--Total Retail leads from 3-Feb-20 and 3-Mar-20
50	4-Mar-20	43	1000	<--Total Retail leads from 4-Feb-20 and 4-Mar-20
51	5-Mar-20	38	1014	<--Total Retail leads from 5-Feb-20 and 5-Mar-20
52	6-Mar-20	39	1030	<--Total Retail leads from 6-Feb-20 and 6-Mar-20
53	7-Mar-20	27	1032	<--Total Retail leads from 7-Feb-20 and 7-Mar-20
54	8-Mar-20	25	1029	<--Total Retail leads from 8-Feb-20 and 8-Mar-20
55	9-Mar-20	44	1033	<--Total Retail leads from 9-Feb-20 and 9-Mar-20
56	10-Mar-20	36	1021	<--Total Retail leads from 10-Feb-20 and 10-Mar-20
57	11-Mar-20	30	984	<--Total Retail leads from 11-Feb-20 and 11-Mar-20
58	12-Mar-20	48	982	<--Total Retail leads from 12-Feb-20 and 12-Mar-20
59	13-Mar-20	17	964	<--Total Retail leads from 13-Feb-20 and 13-Mar-20
60	14-Mar-20	26	931	<--Total Retail leads from 14-Feb-20 and 14-Mar-20
61	15-Mar-20	25	911	<--Total Retail leads from 15-Feb-20 and 15-Mar-20
62	16-Mar-20	45	923	<--Total Retail leads from 16-Feb-20 and 16-Mar-20
63	17-Mar-20	30	909	<--Total Retail leads from 17-Feb-20 and 17-Mar-20
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100