Year 2023

Category Month Sum of SalesVolume

Coffee Jan 9834.99
Feb 7214.66
Mar -0.76
Apr 4127.66
May 4145.49
Jun 742.47
Coffee Result 26064.51
CSP Jan 51901.47
Feb 47331.60
Mar 34574.22
Apr 49657.71
May 48908.94
Jun 5234.94
Jul 4385.19
Aug 4874.91
CSP Result 246868.98
Stills Jan 23041.35
Feb 18321.74
Mar 28901.69
Apr 17421.67
May 16856.63
Jun 3900.60
Jul 987.55
Stills Result 109431.22
Water Jan 7503.58
Feb 1029.47
Mar 4757.89
Apr 5833.54
May -2.77
Jun 103.91
Jul 977.83
Water Result 20203.46
Total Result 402568.17
 Store_id Brand Category Month Year SalesVolume
27344795 Mountain Dew CSP Jan 2022 -43.19
29306680 Zico Water May 2023 -2.77
29106861 Georgia Coffee Mar 2023 -0.76
24660690 Rani CSP May 2022 -0.14
25298585 Aquafina CSP Mar 2022 23.31
27852713 Fanta CSP Jul 2021 84.21
27344795 Zico Water Jun 2023 103.91
24034743 Kinley CSP Jan 2022 128.48
24792773 Georgia Coffee Jul 2021 134.37
2991031 Aquafina CSP Jun 2023 145.41
21362260 Coca-Cola CSP Jul 2022 148.87
29003700 Mountain Dew CSP Jul 2022 152.18
29106861 Georgia Coffee Jul 2022 163.61
27314730 Sprite CSP Apr 2022 215.33
26678079 Fanta CSP Jun 2022 229.77
22625435 Rani CSP Jul 2021 230.08
24034743 Mirinda CSP Mar 2023 233.33
29702708 Sprite CSP Jun 2022 251.32
25459917 Minute Maid Stills Jun 2022 270.27
24034743 Mirinda CSP Jun 2023 279.75
29003700 Mountain Dew CSP Mar 2023 297.38
27314730 Fanta CSP Jun 2023 324.02

24010565 Mirinda CSP Feb 2023 336.09

28131642 Thums Up CSP Jul 2022 378.28

25298585 Kinley CSP Jul 2022 404.05
22078107 Thums Up CSP Jun 2023 459.34
28131642 Thums Up CSP Jun 2022 466.02
21501108 Pepsi CSP Jul 2022 493.08
28393563 Rani CSP Jul 2022 -0.50
28131642 Thums Up CSP Feb 2023 521.47
25784580 Aquafina CSP Jul 2022 522.57
24976068 Kinley CSP Jun 2023 536.64
25784580 Aquafina CSP Jul 2021 565.59
29306680 Sprite CSP Jun 2023 567.09
28393563 Rani CSP Jun 2023 584.40
25784580 Aquafina CSP Jun 2022 603.20
25298585 Kinley CSP Jun 2022 613.57
2991031 Aquafina CSP Apr 2023 614.11
25784580 Minute Maid Stills Jan 2022 615.33
21038003 Mirinda CSP Jun 2022 617.64
21501108 Pepsi CSP Jun 2022 622.55
25784580 Aquafina CSP Mar 2023 633.28
21362260 Coca-Cola CSP Jun 2023 677.00
22145937 Mountain Dew CSP Jun 2022 677.83
27314730 Fanta CSP Jul 2022 679.03
21501108 Pepsi CSP Jul 2021 682.71
21906503 Pepsi CSP Jun 2023 694.54
24034743 Mirinda CSP Jul 2022 732.30
29106861 Georgia Coffee Jun 2023 742.47
29306680 Sprite CSP Jul 2022 749.56
28506284 Minute Maid Stills Jul 2022 755.99
29993536 Coca-Cola CSP Jul 2023 -0.80
2991031 Coca-Cola CSP Jun 2022 804.07
24010565 Mirinda CSP Jul 2023 820.38
28506284 Minute Maid Stills Jun 2023 845.95
23915168 Mountain Dew CSP Jul 2023 846.12
27344795 Zico Water Jul 2022 852.42
21153504 Georgia Coffee Jun 2022 861.26
24981847 Sprite CSP Jul 2023 872.39
21362260 Coca-Cola CSP Jul 2022 889.92
25298585 Kinley CSP Jul 2023 892.12
24660690 Rani CSP Jun 2022 901.81
29306680 Sprite CSP Jan 2023 910.93
21977529 Zico Water Jun 2022 917.40
28131642 Thums Up CSP Jul 2023 954.97
29003700 Mountain Dew CSP Jun 2023 966.75
22684050 Zico Water Jul 2023 977.83
29291387 Minute Maid Stills Jul 2023 988.24
22684050 Zico Water Feb 2023 1029.47
21362260 Thums Up CSP May 2023 1179.42
21362260 Sprite CSP May 2023 1186.62
25298585 Georgia Coffee Feb 2022 1237.05
25298585 Kinley CSP Mar 2023 1283.21
21362260 Fanta CSP Apr 2022 1383.55
28393563 Thums Up CSP Jan 2022 1450.56
28393563 Rani CSP Apr 2023 1476.03
24976068 Sprite CSP Feb 2022 1565.38
27314730 Thums Up CSP Feb 2022 1604.30
25298585 Kinley CSP Feb 2023 1605.05
29003700 Mountain Dew CSP Jan 2023 2010.19
29106861 Fanta CSP Mar 2022 -0.20
21501108 Pepsi CSP May 2022 2057.12
24976068 Maaza Stills Mar 2022 2275.92
28393563 Georgia Coffee Apr 2022 2496.17
27314730 Pepsi CSP May 2023 2519.62
28506284 Aquafina CSP May 2023 2605.99
28393563 Rani CSP Mar 2023 2806.28
22078107 Maaza Stills Jan 2022 2979.44
26678079 Fanta CSP May 2022 3030.41
21977529 Zico Water May 2022 3085.77
29106861 Maaza Stills Feb 2023 3453.89
21501108 Fanta CSP Jan 2022 3501.68
28393563 Rani CSP Jan 2023 3509.95
21906503 Rani CSP Mar 2022 3566.49
21906503 Pepsi CSP Apr 2023 -0.36
25784580 Fanta CSP May 2023 3637.99
2991031 Aquafina CSP Jan 2023 3946.28
21906503 Maaza Stills Feb 2022 3964.88
21501108 Kinley CSP Mar 2022 3972.46
29106861 Georgia Coffee Apr 2023 4127.66
21501108 Georgia Coffee May 2023 4145.49
25784580 Mirinda CSP Feb 2022 4190.35
22145937 Mountain Dew CSP May 2022 4297.24
29003700 Minute Maid Stills Mar 2022 4326.79
21906503 Kinley CSP Apr 2022 4413.41
28506284 Minute Maid Stills Apr 2023 4479.65
27344795 Rani CSP Apr 2022 4484.89
29003700 Thums Up CSP Apr 2022 4697.18
21362260 Coca-Cola CSP Apr 2023 4714.85
27344795 Zico Water Mar 2023 4757.89
25459917 Minute Maid Stills May 2022 4789.78
22625435 Rani CSP Aug 2023 4874.91
29306680 Minute Maid Stills Apr 2022 4932.62
28506284 Minute Maid Stills Mar 2023 4943.78
27314730 Fanta CSP Apr 2023 4961.03
29106861 Pepsi CSP Jan 2022 5033.88
25784580 Aquafina CSP May 2022 5054.97
27314730 Rani CSP Jan 2022 5056.36
27314730 Fanta CSP Mar 2023 5116.56
28393563 Maaza Stills Jan 2023 5139.22
25784580 Coca-Cola CSP Apr 2022 5154.86
2991031 Mirinda CSP Mar 2022 5163.72
29291387 Minute Maid Stills Feb 2023 5394.63
25784580 Mountain Dew CSP May 2023 5445.50
29306680 Sprite CSP Mar 2023 5582.09
27852713 Fanta CSP Feb 2023 5660.13
28506284 Kinley CSP Feb 2022 5665.71
27314730 Minute Maid Stills May 2023 5721.85
27344795 Maaza Stills May 2023 5725.02
24034743 Mirinda CSP Jan 2023 5732.95
29993536 Coca-Cola CSP Feb 2023 5760.31
27344795 Zico Water Apr 2023 5833.54
24034743 Mirinda CSP Apr 2023 5898.73
22078107 Pepsi CSP Apr 2022 6011.83
21501108 Pepsi CSP Mar 2023 6021.53
25298585 Kinley CSP May 2022 6073.42
28131642 Thums Up CSP Mar 2023 6144.55
29106861 Mirinda CSP Apr 2022 6206.98
28506284 Zico Water Apr 2022 6215.76
28131642 Thums Up CSP May 2022 6296.88
27933637 Mountain Dew CSP Mar 2022 6358.73
24981847 Sprite CSP Feb 2023 6431.71
21362260 Coca-Cola CSP Mar 2023 6456.00
2991031 Minute Maid Stills Feb 2022 6471.15
29306680 Sprite CSP Apr 2023 6494.51
21038003 Mirinda CSP May 2022 6753.69
25298585 Coca-Cola CSP May 2023 7105.11
28131642 Rani CSP May 2023 7138.29
28131642 Zico Water Feb 2022 7201.28
24792773 Georgia Coffee Feb 2023 7214.66
2991031 Maaza Stills Apr 2022 7321.39
21501108 Rani CSP Feb 2022 7461.72
27344795 Zico Water Jan 2023 7503.58
24976068 Kinley CSP Apr 2023 7617.41
24034743 Maaza Stills Mar 2023 7869.59
21906503 Fanta CSP Feb 2022 7977.81
29003700 Maaza Stills Apr 2023 7978.27
28506284 Mirinda CSP Jan 2022 8030.70
22078107 Zico Water Mar 2022 8130.43
21501108 Pepsi CSP Feb 2023 8156.89
24976068 Kinley CSP Jan 2023 8389.73
2991031 Coca-Cola CSP May 2022 8403.92
24976068 Georgia Coffee Mar 2022 8472.33
28506284 Minute Maid Stills Jan 2023 8582.11
28131642 Pepsi CSP Mar 2022 8598.26
29306680 Georgia Coffee Jan 2022 8667.36
27314730 Fanta CSP Jan 2023 8799.75
24034743 Mountain Dew CSP Apr 2022 8914.05
29003700 Mountain Dew CSP Apr 2023 8922.23
25298585 Mirinda CSP May 2023 8952.31
22078107 Thums Up CSP Apr 2023 8959.16
21153504 Georgia Coffee May 2022 8983.31
29702708 Sprite CSP May 2022 9056.36
21906503 Pepsi CSP Jan 2023 9123.94
29306680 Kinley CSP May 2023 9138.08
27344795 Aquafina CSP Feb 2022 9257.56
25784580 Aquafina CSP Feb 2023 9275.56
21362260 Mountain Dew CSP Feb 2022 9302.60
26857155 Thums Up CSP Mar 2022 9389.75
22078107 Thums Up CSP Jan 2023 -0.95
21362260 Coca-Cola CSP Jan 2023 9478.70
29003700 Aquafina CSP Jan 2022 9478.97
28131642 Coca-Cola CSP Jan 2022 9506.87
24976068 Aquafina CSP Apr 2022 9514.36
28393563 Coca-Cola CSP Mar 2022 9551.41
23915168 Mountain Dew CSP Feb 2023 9584.39
21362260 Zico Water Jan 2022 9731.22
29306680 Pepsi CSP Feb 2022 -0.98
29106861 Georgia Coffee Jan 2023 9834.99
22078107 Coca-Cola CSP Feb 2022 9878.69
25298585 Sprite CSP Jan 2022 9893.39
24034743 Sprite CSP Mar 2022 9953.55
25459917 Minute Maid Pulpy Stills Jun 2022 3503.49
25784580 Minute Maid Pulpy Stills Jan 2022 7024.50
28506284 Minute Maid Pulpy Stills Jul 2022 8506.24
28506284 Minute Maid Pulpy Stills Jun 2023 3054.65
29291387 Minute Maid Pulpy Stills Jul 2023 -0.69
24976068 Minute Maid Pulpy Stills Mar 2022 -0.76
22078107 Minute Maid Pulpy Stills Jan 2022 5431.91
29106861 Minute Maid Pulpy Stills Feb 2023 4033.52
21906503 Minute Maid Pulpy Stills Feb 2022 8841.95
29003700 Minute Maid Pulpy Stills Mar 2022 8063.78
28506284 Minute Maid Pulpy Stills Apr 2023 1074.26
25459917 Minute Maid Pulpy Stills May 2022 3776.60
29306680 Minute Maid Pulpy Stills Apr 2022 8364.07
28506284 Minute Maid Pulpy Stills Mar 2023 7666.90
28393563 Minute Maid Pulpy Stills Jan 2023 9082.75
29291387 Minute Maid Pulpy Stills Feb 2023 5439.70
27314730 Minute Maid Pulpy Stills May 2023 -0.42
27344795 Minute Maid Pulpy Stills May 2023 5410.18
2991031 Minute Maid Pulpy Stills Feb 2022 2316.19
2991031 Minute Maid Pulpy Stills Apr 2022 5317.03
24034743 Minute Maid Pulpy Stills Mar 2023 8421.42
29003700 Minute Maid Pulpy Stills Apr 2023 3889.48
28506284 Minute Maid Pulpy Stills Jan 2023 237.26
 Date
29-Jan-22
7-May-23
30-Mar-23
1-May-22
24-Mar-22
10-Jul-21
27-Jun-23
4-Jan-22
15-Jul-21
10-Jun-23
19-Jul-22
11-Jul-22
29-Jul-22
28-Apr-22
5-Jun-22
25-Jul-21
26-Mar-23
16-Jun-22
5-Jun-22
2-Jun-23
9-Mar-23
8-Jun-23

17-Feb-23

2-Jul-22
27-Jul-22
28-Jun-23
12-Jun-22
20-Jul-22
12-Jul-22
5-Feb-23
17-Jul-22
16-Jun-23
5-Jul-21
5-Jun-23
16-Jun-23
8-Jun-22
8-Jun-22
23-Apr-23
18-Jan-22
25-Jun-22
 15-Jun-22
1-Mar-23
3-Jun-23
24-Jun-22
9-Jul-22
16-Jul-21
5-Jun-23
6-Jul-22
4-Jun-23
20-Jul-22
1-Jul-22
30-Jul-23
10-Jun-22
14-Jul-23
28-Jun-23
21-Jul-23
15-Jul-22
17-Jun-22
17-Jul-23
1-Jul-22
15-Jul-23
23-Jun-22
23-Jan-23
16-Jun-22
22-Jul-23
16-Jun-23
21-Jul-23
18-Jul-23
29-Mar-23
29-May-23
17-May-23
24-Feb-22
16-Mar-23
18-Apr-22
28-Jan-22
28-Apr-23
17-Feb-22
3-Feb-22
22-Feb-23
5-Jan-23
28-Mar-22
3-May-22
24-Mar-22
11-Apr-22
15-May-23
8-May-23
17-Mar-23
 25-Jan-22
2-May-22
11-May-22
12-Feb-23
21-Jan-22
21-Jan-23
29-Mar-22
5-Apr-23
6-May-23
17-Jan-23
30-Mar-22
14-Mar-22
12-Apr-23
24-May-23
5-Feb-22
3-May-22
12-Mar-22
9-Apr-22
17-Apr-23
14-Apr-22
22-Apr-22
18-Apr-23
13-Mar-23
28-May-22
29-Aug-23
23-Apr-22
1-Mar-23
4-Apr-23
25-Jan-22
16-May-22
7-Jan-22
20-Mar-23
14-Jan-23
29-Apr-22
16-Mar-22
12-Feb-23
16-May-23
26-Mar-23
25-Feb-23
26-Feb-22
28-May-23
9-May-23
1-Jan-23
10-Feb-23
26-Apr-23
18-Apr-23
7-Apr-22
21-Mar-23
6-May-22
8-Mar-23
26-Apr-22
7-Apr-22
1-May-22
29-Mar-22
23-Feb-23
11-Mar-23
1-Feb-22
24-Apr-23
27-May-22
7-May-23
2-May-23
28-Feb-22
25-Feb-23
3-Apr-22
12-Aug-22
30-Jan-23
20-Apr-23
16-Mar-23
28-Feb-22
30-Apr-23
7-Jan-22
28-Mar-22
16-Feb-23
5-Jan-23
19-May-22
19-Mar-22
12-Jan-23
18-Mar-22
4-Jan-22
8-Jan-23
7-Apr-22
28-Apr-23
9-May-23
14-Apr-23
30-May-22
17-May-22
5-Jan-23
25-May-23
18-Feb-22
24-Feb-23
19-Sep-22
26-Mar-22
26-Jan-23
5-Jan-23
 19-Jan-22
15-Jan-22
20-Apr-22
27-Mar-22
10-Feb-23
11-Jan-22
18-Feb-22
30-Jan-23
8-Feb-22
3-Jan-22
15-Mar-22
10-Jun-22
4-Jan-22
10-Jul-22
21-Jun-23
1-Jul-23
28-Mar-22
6-Jan-22
2-Feb-23
3-Feb-22
20-Mar-22
6-Apr-23
14-May-22
21-Apr-22
21-Mar-23
7-Jan-23
18-Feb-23
11-May-23
16-May-23
23-Feb-22
27-Apr-22
29-Mar-23
2-Apr-23
28-Jan-23
1. Write a query to find the top 3 stores with the highest average sales volume per day in the last 30 days
2. Write a SQL query to identify the top 2 beverage categories that have shown consistent growth in sales
volume over the past 6 months

Q1) Expected Output Sample

Store
Store1
Store2
Store3

Q2) Expected Output Sample

Beverage Category
Coffee
Coffee

Q1

select top 3 Store_id,

sum(Sales_Volume)/datediff(Day, min(Date),max(Date)) as Avg_sales_per_day
from dbo.Book1$
group by Store_id
having datediff(Day, min(Date),max(Date)) >= 30
order by Avg_sales_per_day desc

Q2
select *,
sum(Sales) over(Partition by Category order by years rows between unbounded preceding and current row) as MTD from
(select Category,Year(Date)as years,Month(Date) as months,sum(Sales_Volume) as sales from dbo.Book1$ where Year(Date) =
group by Category,Month(Date),Year(Date))tb1
 AverageSalesVolumePerDay
1500
1200
1000

Total Sales Volume

5000
4500

and current row) as MTD from

om dbo.Book1$ where Year(Date) = '2023' and Month(Date) not in ('8','7')
Period Company Metric Sales_Values
1/1/2023 CompA Sales Vol 72947.307 3) Create Month wise YTD Level Data for
1/2/2023 CompA Sales Vol 21553.659
1/3/2023 CompA Sales Vol 777.6832
1/4/2023 CompA Sales Vol 34871.112
1/5/2023 CompA Sales Vol 42598.065
1/6/2023 CompA Sales Vol 47924.887 Q3) Expected Output Sample
1/7/2023 CompA Sales Vol 24611.591
1/8/2023 CompA Sales Vol 15623.662 Company
1/9/2023 CompA Sales Vol 49457.781 CompA
1/10/2023 CompA Sales Vol 11886.296 CompA
1/11/2023 CompA Sales Vol 99688.104 CompA
1/12/2023 CompA Sales Vol 68013.107 CompA
1/13/2023 CompA Sales Vol 42757 CompA
1/14/2023 CompA Sales Vol 97137.478 CompA
1/15/2023 CompA Sales Vol 92556.034 CompA
1/16/2023 CompA Sales Vol 12252.942 CompA
1/17/2023 CompA Sales Vol 73986.935 CompB
1/18/2023 CompA Sales Vol 73414.316 CompB
1/19/2023 CompA Sales Vol 68350.141 CompB
1/20/2023 CompA Sales Vol 68371.031 CompB
1/21/2023 CompA Sales Vol 36670.393 CompB
1/22/2023 CompA Sales Vol 80557.019 CompB
1/23/2023 CompA Sales Vol 29021.255 CompB
1/24/2023 CompA Sales Vol 30609.346 CompB
1/25/2023 CompA Sales Vol 6445.1675
2/1/2023 CompA Sales Vol 12754.399
2/2/2023 CompA Sales Vol 47363.618 select *,
2/3/2023 CompA Sales Vol 95741.324 sum(Sales) over(Partition by Company ord
2/4/2023 CompA Sales Vol 65461.332 (select Company,Metric,Year(Period)as ye
2/5/2023 CompA Sales Vol 2629.1194 group by Company,Metric,Month(Period),
2/6/2023 CompA Sales Vol 93489.068
2/7/2023 CompA Sales Vol 26517.132
2/8/2023 CompA Sales Vol 99303.523
2/9/2023 CompA Sales Vol 61803.749
2/10/2023 CompA Sales Vol 8544.8166
2/11/2023 CompA Sales Vol 91681.272
2/12/2023 CompA Sales Vol 26609.449
2/13/2023 CompA Sales Vol 46361.042
2/14/2023 CompA Sales Vol 86055.725
2/15/2023 CompA Sales Vol 4174.5574
2/16/2023 CompA Sales Vol 33892.136
2/17/2023 CompA Sales Vol 93504.079
2/18/2023 CompA Sales Vol 71537.552
2/19/2023 CompA Sales Vol 24839.956
2/20/2023 CompA Sales Vol 86075.097
2/21/2023 CompA Sales Vol 71973.504
2/22/2023 CompA Sales Vol 4651.3316
2/23/2023 CompA Sales Vol 13904.267
2/24/2023 CompA Sales Vol 78354.116
2/25/2023 CompA Sales Vol 85017.643
3/1/2023 CompA Sales Vol 95841.117
3/2/2023 CompA Sales Vol 85513.342
3/3/2023 CompA Sales Vol 63643.665
3/4/2023 CompA Sales Vol 64357.686
3/5/2023 CompA Sales Vol 3864.1867
3/6/2023 CompA Sales Vol 28979.663
3/7/2023 CompA Sales Vol 96922.915
3/8/2023 CompA Sales Vol 4256.0945
3/9/2023 CompA Sales Vol 81569.617
3/10/2023 CompA Sales Vol 98494.319
3/11/2023 CompA Sales Vol 71154.203
3/12/2023 CompA Sales Vol 26167.301
3/13/2023 CompA Sales Vol 26606.551
3/14/2023 CompA Sales Vol 54901.7
3/15/2023 CompA Sales Vol 17976.449
3/16/2023 CompA Sales Vol 53891.885
3/17/2023 CompA Sales Vol 47462.542
3/18/2023 CompA Sales Vol 34659.958
3/19/2023 CompA Sales Vol 35242.742
3/20/2023 CompA Sales Vol 66272.45
3/21/2023 CompA Sales Vol 17927.137
3/22/2023 CompA Sales Vol 27657.342
3/23/2023 CompA Sales Vol 35133.29
3/24/2023 CompA Sales Vol 58560.83
3/25/2023 CompA Sales Vol 99811.101
4/1/2023 CompA Sales Vol 71877.888
4/2/2023 CompA Sales Vol 78223.779
4/3/2023 CompA Sales Vol 50860.814
4/4/2023 CompA Sales Vol 40498.851
4/5/2023 CompA Sales Vol 59523.805
4/6/2023 CompA Sales Vol 58690.343
4/7/2023 CompA Sales Vol 47375.118
4/8/2023 CompA Sales Vol 73038.797
4/9/2023 CompA Sales Vol 60616.674
4/10/2023 CompA Sales Vol 98859.078
4/11/2023 CompA Sales Vol 33020.543
4/12/2023 CompA Sales Vol 91297.138
4/13/2023 CompA Sales Vol 66000.915
4/14/2023 CompA Sales Vol 91529.53
4/15/2023 CompA Sales Vol 93129.703
4/16/2023 CompA Sales Vol 37804.638
4/17/2023 CompA Sales Vol 24050.772
4/18/2023 CompA Sales Vol 91995.54
4/19/2023 CompA Sales Vol 33686.619
4/20/2023 CompA Sales Vol 6502.5857
4/21/2023 CompA Sales Vol 70250.977
4/22/2023 CompA Sales Vol 28469.544
4/23/2023 CompA Sales Vol 89764.156
4/24/2023 CompA Sales Vol 2983.3603
4/25/2023 CompA Sales Vol 73885.417
1/1/2023 CompB Sales Vol 96896.297
1/2/2023 CompB Sales Vol 63864.593
1/3/2023 CompB Sales Vol 91431.822
1/4/2023 CompB Sales Vol 2445.2869
1/5/2023 CompB Sales Vol 45608.609
1/6/2023 CompB Sales Vol 93826.683
1/7/2023 CompB Sales Vol 89699.619
1/8/2023 CompB Sales Vol 43332.074
1/9/2023 CompB Sales Vol 94811.593
1/10/2023 CompB Sales Vol 73940.006
1/11/2023 CompB Sales Vol 19420.643
1/12/2023 CompB Sales Vol 69339.845
1/13/2023 CompB Sales Vol 95500.395
1/14/2023 CompB Sales Vol 23895.511
1/15/2023 CompB Sales Vol 57521.573
1/16/2023 CompB Sales Vol 31848.995
1/17/2023 CompB Sales Vol 12725.882
1/18/2023 CompB Sales Vol 75201.803
1/19/2023 CompB Sales Vol 25920.711
1/20/2023 CompB Sales Vol 36925.241
1/21/2023 CompB Sales Vol 13418.616
1/22/2023 CompB Sales Vol 50071.377
1/23/2023 CompB Sales Vol 34291.585
1/24/2023 CompB Sales Vol 31853.112
1/25/2023 CompB Sales Vol 75701.865
2/1/2023 CompB Sales Vol 52737.655
2/2/2023 CompB Sales Vol 98510.07
2/3/2023 CompB Sales Vol 20685.934
2/4/2023 CompB Sales Vol 16165.209
2/5/2023 CompB Sales Vol 95615.082
2/6/2023 CompB Sales Vol 94444.165
2/7/2023 CompB Sales Vol 83891.484
2/8/2023 CompB Sales Vol 82861.538
2/9/2023 CompB Sales Vol 26278.382
2/10/2023 CompB Sales Vol 40523.273
2/11/2023 CompB Sales Vol 80501.615
2/12/2023 CompB Sales Vol 84479.25
2/13/2023 CompB Sales Vol 93796.721
2/14/2023 CompB Sales Vol 86555.663
2/15/2023 CompB Sales Vol 88213.213
2/16/2023 CompB Sales Vol 69152.754
2/17/2023 CompB Sales Vol 1522.7295
2/18/2023 CompB Sales Vol 11973.736
2/19/2023 CompB Sales Vol 49067.699
2/20/2023 CompB Sales Vol 62450.35
2/21/2023 CompB Sales Vol 91827.417
2/22/2023 CompB Sales Vol 4246.8522
2/23/2023 CompB Sales Vol 85766.987
2/24/2023 CompB Sales Vol 9517.254
2/25/2023 CompB Sales Vol 32236.193
3/1/2023 CompB Sales Vol 72336.238
3/2/2023 CompB Sales Vol 4980.952
3/3/2023 CompB Sales Vol 16134.849
3/4/2023 CompB Sales Vol 27050.299
3/5/2023 CompB Sales Vol 69628.616
3/6/2023 CompB Sales Vol 74036.509
3/7/2023 CompB Sales Vol 64264.315
3/8/2023 CompB Sales Vol 64651.452
3/9/2023 CompB Sales Vol 29618.918
3/10/2023 CompB Sales Vol 96665.925
3/11/2023 CompB Sales Vol 50877.373
3/12/2023 CompB Sales Vol 99637.958
3/13/2023 CompB Sales Vol 32004.383
3/14/2023 CompB Sales Vol 22873.873
3/15/2023 CompB Sales Vol 66950.222
3/16/2023 CompB Sales Vol 80680.477
3/17/2023 CompB Sales Vol 41831.873
3/18/2023 CompB Sales Vol 83375.068
3/19/2023 CompB Sales Vol 52812.555
3/20/2023 CompB Sales Vol 54064.876
3/21/2023 CompB Sales Vol 59702.571
3/22/2023 CompB Sales Vol 6518.3719
3/23/2023 CompB Sales Vol 75149.927
3/24/2023 CompB Sales Vol 22151.428
3/25/2023 CompB Sales Vol 74715.602
4/1/2023 CompB Sales Vol 19021.726
4/2/2023 CompB Sales Vol 82969.56
4/3/2023 CompB Sales Vol 41146.464
4/4/2023 CompB Sales Vol 64106.379
4/5/2023 CompB Sales Vol 86003.009
4/6/2023 CompB Sales Vol 41194.041
4/7/2023 CompB Sales Vol 76961.29
4/8/2023 CompB Sales Vol 3135.1565
4/9/2023 CompB Sales Vol 16991.857
4/10/2023 CompB Sales Vol 64029.846
4/11/2023 CompB Sales Vol 87805.068
4/12/2023 CompB Sales Vol 31849.434
4/13/2023 CompB Sales Vol 96861.611
4/14/2023 CompB Sales Vol 47877
4/15/2023 CompB Sales Vol 39582.036
4/16/2023 CompB Sales Vol 55835.952
4/17/2023 CompB Sales Vol 48063.695
4/18/2023 CompB Sales Vol 91941.649
4/19/2023 CompB Sales Vol 10208.068
4/20/2023 CompB Sales Vol 14224.79
4/21/2023 CompB Sales Vol 9288.011
4/22/2023 CompB Sales Vol 74906.743
4/23/2023 CompB Sales Vol 40329.246
4/24/2023 CompB Sales Vol 60030.445
4/25/2023 CompB Sales Vol 13821.444
1/1/2023 CompC Sales Vol 2074.3938
1/2/2023 CompC Sales Vol 52019.986
1/3/2023 CompC Sales Vol 38416.439
1/4/2023 CompC Sales Vol 27788.397
1/5/2023 CompC Sales Vol 90268.487
1/6/2023 CompC Sales Vol 84586.851
1/7/2023 CompC Sales Vol 89324.242
1/8/2023 CompC Sales Vol 11627.265
1/9/2023 CompC Sales Vol 28196.403
1/10/2023 CompC Sales Vol 62706.334
1/11/2023 CompC Sales Vol 87685.058
1/12/2023 CompC Sales Vol 7213.39
1/13/2023 CompC Sales Vol 79650.064
1/14/2023 CompC Sales Vol 7701.1958
1/15/2023 CompC Sales Vol 25573.135
1/16/2023 CompC Sales Vol 75990.424
1/17/2023 CompC Sales Vol 13818.189
1/18/2023 CompC Sales Vol 66059.386
1/19/2023 CompC Sales Vol 78197.362
1/20/2023 CompC Sales Vol 22334.245
1/21/2023 CompC Sales Vol 96602.924
1/22/2023 CompC Sales Vol 28711.952
1/23/2023 CompC Sales Vol 9478.3982
1/24/2023 CompC Sales Vol 87435.789
1/25/2023 CompC Sales Vol 69262.013
2/1/2023 CompC Sales Vol 85877.246
2/2/2023 CompC Sales Vol 99446.889
2/3/2023 CompC Sales Vol 79983.315
2/4/2023 CompC Sales Vol 43829.029
2/5/2023 CompC Sales Vol 81144.021
2/6/2023 CompC Sales Vol 68391.47
2/7/2023 CompC Sales Vol 29841.537
2/8/2023 CompC Sales Vol 51530.271
2/9/2023 CompC Sales Vol 72444.64
2/10/2023 CompC Sales Vol 63272.254
2/11/2023 CompC Sales Vol 53296.159
2/12/2023 CompC Sales Vol 90016.318
2/13/2023 CompC Sales Vol 16314.864
2/14/2023 CompC Sales Vol 34510.583
2/15/2023 CompC Sales Vol 19055.304
2/16/2023 CompC Sales Vol 50484.221
2/17/2023 CompC Sales Vol 10439.592
2/18/2023 CompC Sales Vol 816.1978
2/19/2023 CompC Sales Vol 25849.554
2/20/2023 CompC Sales Vol 83446.39
2/21/2023 CompC Sales Vol 39169.64
2/22/2023 CompC Sales Vol 33232.335
2/23/2023 CompC Sales Vol 88135.224
2/24/2023 CompC Sales Vol 89610.332
2/25/2023 CompC Sales Vol 24588.105
3/1/2023 CompC Sales Vol 48717.176
3/2/2023 CompC Sales Vol 5521.2255
3/3/2023 CompC Sales Vol 33315.281
3/4/2023 CompC Sales Vol 62074.188
3/5/2023 CompC Sales Vol 67391.781
3/6/2023 CompC Sales Vol 55394.243
3/7/2023 CompC Sales Vol 85605.67
3/8/2023 CompC Sales Vol 52667.258
3/9/2023 CompC Sales Vol 32551.055
3/10/2023 CompC Sales Vol 90594.031
3/11/2023 CompC Sales Vol 34224.322
3/12/2023 CompC Sales Vol 75050.116
3/13/2023 CompC Sales Vol 4572.0889
3/14/2023 CompC Sales Vol 78602.4
3/15/2023 CompC Sales Vol 65171.865
3/16/2023 CompC Sales Vol 55617.58
3/17/2023 CompC Sales Vol 89877.858
3/18/2023 CompC Sales Vol 40792.875
3/19/2023 CompC Sales Vol 91129.692
3/20/2023 CompC Sales Vol 82643.399
3/21/2023 CompC Sales Vol 33973.349
3/22/2023 CompC Sales Vol 26327.425
3/23/2023 CompC Sales Vol 84660.223
3/24/2023 CompC Sales Vol 95269.461
3/25/2023 CompC Sales Vol 37349.075
4/1/2023 CompC Sales Vol 26174.255
4/2/2023 CompC Sales Vol 20113.187
4/3/2023 CompC Sales Vol 72783.499
4/4/2023 CompC Sales Vol 62948.602
4/5/2023 CompC Sales Vol 51342.415
4/6/2023 CompC Sales Vol 57606.768
 4/7/2023 CompC Sales Vol 77244.283
4/8/2023 CompC Sales Vol 31993.906
4/9/2023 CompC Sales Vol 31504.379
4/10/2023 CompC Sales Vol 11585.184
4/11/2023 CompC Sales Vol 21630.227
4/12/2023 CompC Sales Vol 89860.157
4/13/2023 CompC Sales Vol 21548.575
4/14/2023 CompC Sales Vol 52863.515
4/15/2023 CompC Sales Vol 5754.2662
4/16/2023 CompC Sales Vol 1720.6829
4/17/2023 CompC Sales Vol 75767.945
4/18/2023 CompC Sales Vol 60157.115
4/19/2023 CompC Sales Vol 77584.499
4/20/2023 CompC Sales Vol 23352.046
4/21/2023 CompC Sales Vol 40593.355
4/22/2023 CompC Sales Vol 52307.138
4/23/2023 CompC Sales Vol 46984.386
4/24/2023 CompC Sales Vol 86757.429
4/25/2023 CompC Sales Vol 49868.392
1/1/2023 CompD Sales Vol 87169.907
1/2/2023 CompD Sales Vol 23702.823
1/3/2023 CompD Sales Vol 22927.675
1/4/2023 CompD Sales Vol 2903.1055
1/5/2023 CompD Sales Vol 11228.321
1/6/2023 CompD Sales Vol 64869.126
1/7/2023 CompD Sales Vol 40727.478
1/8/2023 CompD Sales Vol 55175.855
1/9/2023 CompD Sales Vol 17268.505
1/10/2023 CompD Sales Vol 139.21213
1/11/2023 CompD Sales Vol 37574.87
1/12/2023 CompD Sales Vol 2913.6972
1/13/2023 CompD Sales Vol 32582.245
1/14/2023 CompD Sales Vol 10979.789
1/15/2023 CompD Sales Vol 10460.555
1/16/2023 CompD Sales Vol 44567.223
1/17/2023 CompD Sales Vol 18584.831
1/18/2023 CompD Sales Vol 36882.277
1/19/2023 CompD Sales Vol 73790.881
1/20/2023 CompD Sales Vol 97484.684
1/21/2023 CompD Sales Vol 8075.7606
1/22/2023 CompD Sales Vol 69378.079
1/23/2023 CompD Sales Vol 13530.55
1/24/2023 CompD Sales Vol 83478.818
1/25/2023 CompD Sales Vol 36027.669
2/1/2023 CompD Sales Vol 39217.672
2/2/2023 CompD Sales Vol 94856.086
2/3/2023 CompD Sales Vol 59956.495
 2/4/2023 CompD Sales Vol 66216.805
2/5/2023 CompD Sales Vol 61407.406
2/6/2023 CompD Sales Vol 44377.818
2/7/2023 CompD Sales Vol 69522.063
2/8/2023 CompD Sales Vol 30241.082
2/9/2023 CompD Sales Vol 11349.688
2/10/2023 CompD Sales Vol 603.85819
2/11/2023 CompD Sales Vol 18189.1
2/12/2023 CompD Sales Vol 86635.937
2/13/2023 CompD Sales Vol 92437.573
2/14/2023 CompD Sales Vol 24045.152
2/15/2023 CompD Sales Vol 56544.273
2/16/2023 CompD Sales Vol 63890.454
2/17/2023 CompD Sales Vol 84878.952
2/18/2023 CompD Sales Vol 44363.661
2/19/2023 CompD Sales Vol 46072.807
2/20/2023 CompD Sales Vol 16068.425
2/21/2023 CompD Sales Vol 43636.522
2/22/2023 CompD Sales Vol 58638.715
2/23/2023 CompD Sales Vol 2931.633
2/24/2023 CompD Sales Vol 43522.673
2/25/2023 CompD Sales Vol 87752.355
3/1/2023 CompD Sales Vol 7734.9257
3/2/2023 CompD Sales Vol 58416.739
3/3/2023 CompD Sales Vol 17388.944
3/4/2023 CompD Sales Vol 30939.09
3/5/2023 CompD Sales Vol 49109.847
3/6/2023 CompD Sales Vol 46383.539
3/7/2023 CompD Sales Vol 11455.059
3/8/2023 CompD Sales Vol 48042.042
3/9/2023 CompD Sales Vol 58636.748
3/10/2023 CompD Sales Vol 10539.278
3/11/2023 CompD Sales Vol 30249.164
3/12/2023 CompD Sales Vol 88821.902
3/13/2023 CompD Sales Vol 86636.934
3/14/2023 CompD Sales Vol 84015.739
3/15/2023 CompD Sales Vol 58121.087
3/16/2023 CompD Sales Vol 11760.363
3/17/2023 CompD Sales Vol 54705.889
3/18/2023 CompD Sales Vol 1282.4767
3/19/2023 CompD Sales Vol 54590.823
3/20/2023 CompD Sales Vol 21639.655
3/21/2023 CompD Sales Vol 24953.49
3/22/2023 CompD Sales Vol 92241.334
3/23/2023 CompD Sales Vol 76227.578
3/24/2023 CompD Sales Vol 16638.258
3/25/2023 CompD Sales Vol 4158.1956
 4/1/2023 CompD Sales Vol 11093.144
4/2/2023 CompD Sales Vol 16934.464
4/3/2023 CompD Sales Vol 15925.287
4/4/2023 CompD Sales Vol 39717.589
4/5/2023 CompD Sales Vol 67789.964
4/6/2023 CompD Sales Vol 21017.11
4/7/2023 CompD Sales Vol 14114.874
4/8/2023 CompD Sales Vol 85336.208
4/9/2023 CompD Sales Vol 43351.643
4/10/2023 CompD Sales Vol 38972.062
4/11/2023 CompD Sales Vol 107.09231
4/12/2023 CompD Sales Vol 96711.704
4/13/2023 CompD Sales Vol 49557.661
4/14/2023 CompD Sales Vol 87051.713
4/15/2023 CompD Sales Vol 38689.989
4/16/2023 CompD Sales Vol 79027.366
4/17/2023 CompD Sales Vol 95895.97
4/18/2023 CompD Sales Vol 87992.879
4/19/2023 CompD Sales Vol 587.46569
4/20/2023 CompD Sales Vol 811.25066
4/21/2023 CompD Sales Vol 6794.8143
4/22/2023 CompD Sales Vol 59007.461
4/23/2023 CompD Sales Vol 52886.611
4/24/2023 CompD Sales Vol 86600.46
4/25/2023 CompD Sales Vol 74708.853
1/1/2023 CompA Sales Val 89724.182
1/2/2023 CompA Sales Val 87349.515
1/3/2023 CompA Sales Val 48390.936
1/4/2023 CompA Sales Val 44886.286
1/5/2023 CompA Sales Val 60194.437
1/6/2023 CompA Sales Val 36234.835
1/7/2023 CompA Sales Val 55881.067
1/8/2023 CompA Sales Val 79958.064
1/9/2023 CompA Sales Val 48207.875
1/10/2023 CompA Sales Val 29570.317
1/11/2023 CompA Sales Val 48511.215
1/12/2023 CompA Sales Val 89613.482
1/13/2023 CompA Sales Val 28749.774
1/14/2023 CompA Sales Val 37599.142
1/15/2023 CompA Sales Val 40763.127
1/16/2023 CompA Sales Val 85581.02
1/17/2023 CompA Sales Val 26603.745
1/18/2023 CompA Sales Val 55163.859
1/19/2023 CompA Sales Val 60889.142
1/20/2023 CompA Sales Val 12380.5
1/21/2023 CompA Sales Val 80067.126
1/22/2023 CompA Sales Val 45592.42
1/23/2023 CompA Sales Val 84033.868
1/24/2023 CompA Sales Val 1179.7699
1/25/2023 CompA Sales Val 4552.4737
2/1/2023 CompA Sales Val 78590.712
2/2/2023 CompA Sales Val 38454.817
2/3/2023 CompA Sales Val 30154.665
2/4/2023 CompA Sales Val 81539.369
2/5/2023 CompA Sales Val 11303.256
2/6/2023 CompA Sales Val 94266.528
2/7/2023 CompA Sales Val 11362.251
2/8/2023 CompA Sales Val 91986.693
2/9/2023 CompA Sales Val 97991.727
2/10/2023 CompA Sales Val 54660.969
2/11/2023 CompA Sales Val 11901.501
2/12/2023 CompA Sales Val 76400.88
2/13/2023 CompA Sales Val 16542.204
2/14/2023 CompA Sales Val 5053.1439
2/15/2023 CompA Sales Val 3371.2441
2/16/2023 CompA Sales Val 73489.493
2/17/2023 CompA Sales Val 77578.155
2/18/2023 CompA Sales Val 22802.1
2/19/2023 CompA Sales Val 67864.975
2/20/2023 CompA Sales Val 88210.529
2/21/2023 CompA Sales Val 78538.014
2/22/2023 CompA Sales Val 84887.959
2/23/2023 CompA Sales Val 40310.475
2/24/2023 CompA Sales Val 33891.496
2/25/2023 CompA Sales Val 15447.622
3/1/2023 CompA Sales Val 69463.401
3/2/2023 CompA Sales Val 6395.8232
3/3/2023 CompA Sales Val 71778.952
3/4/2023 CompA Sales Val 32799.57
3/5/2023 CompA Sales Val 20582.815
3/6/2023 CompA Sales Val 45471.366
3/7/2023 CompA Sales Val 69375.758
3/8/2023 CompA Sales Val 56201.036
3/9/2023 CompA Sales Val 86118.404
3/10/2023 CompA Sales Val 81174.211
3/11/2023 CompA Sales Val 68476.439
3/12/2023 CompA Sales Val 66284.913
3/13/2023 CompA Sales Val 66140.451
3/14/2023 CompA Sales Val 83309.499
3/15/2023 CompA Sales Val 37047.482
3/16/2023 CompA Sales Val 53671.377
3/17/2023 CompA Sales Val 60376.582
3/18/2023 CompA Sales Val 2929.2193
3/19/2023 CompA Sales Val 72986.253
3/20/2023 CompA Sales Val 25197.584
3/21/2023 CompA Sales Val 74314.965
3/22/2023 CompA Sales Val 4917.2359
3/23/2023 CompA Sales Val 33651.731
3/24/2023 CompA Sales Val 99243.915
3/25/2023 CompA Sales Val 55905.836
4/1/2023 CompA Sales Val 30447.707
4/2/2023 CompA Sales Val 47877.915
4/3/2023 CompA Sales Val 8967.7286
4/4/2023 CompA Sales Val 94467.381
4/5/2023 CompA Sales Val 79089.805
4/6/2023 CompA Sales Val 94731.177
4/7/2023 CompA Sales Val 66870.425
4/8/2023 CompA Sales Val 87259.543
4/9/2023 CompA Sales Val 33370.157
4/10/2023 CompA Sales Val 47140.325
4/11/2023 CompA Sales Val 43190.404
4/12/2023 CompA Sales Val 48485.43
4/13/2023 CompA Sales Val 72948.41
4/14/2023 CompA Sales Val 2142.7231
4/15/2023 CompA Sales Val 35376.083
4/16/2023 CompA Sales Val 5351.6072
4/17/2023 CompA Sales Val 5142.5564
4/18/2023 CompA Sales Val 2335.7637
4/19/2023 CompA Sales Val 99714.064
4/20/2023 CompA Sales Val 27870.139
4/21/2023 CompA Sales Val 52831.247
4/22/2023 CompA Sales Val 37934.724
4/23/2023 CompA Sales Val 8289.9973
4/24/2023 CompA Sales Val 96740.818
4/25/2023 CompA Sales Val 33956.59
1/1/2023 CompB Sales Val 83057.178
1/2/2023 CompB Sales Val 40349.479
1/3/2023 CompB Sales Val 40583.916
1/4/2023 CompB Sales Val 89871.738
1/5/2023 CompB Sales Val 66543.026
1/6/2023 CompB Sales Val 44874.687
1/7/2023 CompB Sales Val 29063.229
1/8/2023 CompB Sales Val 39508.061
1/9/2023 CompB Sales Val 54765.874
1/10/2023 CompB Sales Val 39305.876
1/11/2023 CompB Sales Val 87036.878
1/12/2023 CompB Sales Val 62315.283
1/13/2023 CompB Sales Val 571.93964
1/14/2023 CompB Sales Val 84850.361
1/15/2023 CompB Sales Val 38989.653
1/16/2023 CompB Sales Val 34694.458
1/17/2023 CompB Sales Val 90801.493
1/18/2023 CompB Sales Val 93048.892
1/19/2023 CompB Sales Val 3689.1566
1/20/2023 CompB Sales Val 30573.237
1/21/2023 CompB Sales Val 22516.449
1/22/2023 CompB Sales Val 70757.553
1/23/2023 CompB Sales Val 24594.185
1/24/2023 CompB Sales Val 71603.746
1/25/2023 CompB Sales Val 22431.398
2/1/2023 CompB Sales Val 92714.849
2/2/2023 CompB Sales Val 85486.156
2/3/2023 CompB Sales Val 40449.191
2/4/2023 CompB Sales Val 46376.043
2/5/2023 CompB Sales Val 50738.187
2/6/2023 CompB Sales Val 19576.396
2/7/2023 CompB Sales Val 30815.211
2/8/2023 CompB Sales Val 21099.65
2/9/2023 CompB Sales Val 51937.886
2/10/2023 CompB Sales Val 56748.039
2/11/2023 CompB Sales Val 47456.112
2/12/2023 CompB Sales Val 29775.951
2/13/2023 CompB Sales Val 63979.434
2/14/2023 CompB Sales Val 73023.679
2/15/2023 CompB Sales Val 95680.596
2/16/2023 CompB Sales Val 17729.147
2/17/2023 CompB Sales Val 59176.88
2/18/2023 CompB Sales Val 85521.319
2/19/2023 CompB Sales Val 28184.605
2/20/2023 CompB Sales Val 41701.584
2/21/2023 CompB Sales Val 3606.5766
2/22/2023 CompB Sales Val 10630.621
2/23/2023 CompB Sales Val 79835.987
2/24/2023 CompB Sales Val 12005.619
2/25/2023 CompB Sales Val 93897.967
3/1/2023 CompB Sales Val 53076.928
3/2/2023 CompB Sales Val 40484.093
3/3/2023 CompB Sales Val 60375.345
3/4/2023 CompB Sales Val 29922.744
3/5/2023 CompB Sales Val 62676.611
3/6/2023 CompB Sales Val 92709.121
3/7/2023 CompB Sales Val 72776.01
3/8/2023 CompB Sales Val 40026.432
3/9/2023 CompB Sales Val 25174.576
3/10/2023 CompB Sales Val 1602.0578
3/11/2023 CompB Sales Val 66113.352
3/12/2023 CompB Sales Val 38410.517
3/13/2023 CompB Sales Val 94677.198
3/14/2023 CompB Sales Val 2992.1567
3/15/2023 CompB Sales Val 37701.569
3/16/2023 CompB Sales Val 55012.484
3/17/2023 CompB Sales Val 32276.43
3/18/2023 CompB Sales Val 23685.651
3/19/2023 CompB Sales Val 54400.969
3/20/2023 CompB Sales Val 7303.0617
3/21/2023 CompB Sales Val 71976.571
3/22/2023 CompB Sales Val 48510.354
3/23/2023 CompB Sales Val 26165.221
3/24/2023 CompB Sales Val 61586.569
3/25/2023 CompB Sales Val 84000.846
4/1/2023 CompB Sales Val 70979.187
4/2/2023 CompB Sales Val 24316.79
4/3/2023 CompB Sales Val 47007.651
4/4/2023 CompB Sales Val 74328.722
4/5/2023 CompB Sales Val 35376
4/6/2023 CompB Sales Val 33844.843
4/7/2023 CompB Sales Val 38217.785
4/8/2023 CompB Sales Val 46357.133
4/9/2023 CompB Sales Val 52087.773
4/10/2023 CompB Sales Val 30594.193
4/11/2023 CompB Sales Val 24403.764
4/12/2023 CompB Sales Val 69401.405
4/13/2023 CompB Sales Val 21922.934
4/14/2023 CompB Sales Val 94011.864
4/15/2023 CompB Sales Val 74699.889
4/16/2023 CompB Sales Val 95886.037
4/17/2023 CompB Sales Val 5245.957
4/18/2023 CompB Sales Val 33769.953
4/19/2023 CompB Sales Val 84660.851
4/20/2023 CompB Sales Val 38496.201
4/21/2023 CompB Sales Val 88247.658
4/22/2023 CompB Sales Val 79811.56
4/23/2023 CompB Sales Val 14620.919
4/24/2023 CompB Sales Val 36703.04
4/25/2023 CompB Sales Val 96905.698
1/1/2023 CompC Sales Val 90405.73
1/2/2023 CompC Sales Val 64763.913
1/3/2023 CompC Sales Val 40480.111
1/4/2023 CompC Sales Val 5246.5772
1/5/2023 CompC Sales Val 82960
1/6/2023 CompC Sales Val 90503.237
1/7/2023 CompC Sales Val 70397.91
1/8/2023 CompC Sales Val 21955.027
1/9/2023 CompC Sales Val 69946.163
1/10/2023 CompC Sales Val 40876.667
1/11/2023 CompC Sales Val 64045.213
1/12/2023 CompC Sales Val 54477.637
1/13/2023 CompC Sales Val 97632.13
1/14/2023 CompC Sales Val 14747.533
1/15/2023 CompC Sales Val 50708.982
1/16/2023 CompC Sales Val 87502.126
1/17/2023 CompC Sales Val 29184.222
1/18/2023 CompC Sales Val 30159.449
1/19/2023 CompC Sales Val 11744.007
1/20/2023 CompC Sales Val 86629.314
1/21/2023 CompC Sales Val 44546.435
1/22/2023 CompC Sales Val 84046.849
1/23/2023 CompC Sales Val 60368.567
1/24/2023 CompC Sales Val 79124.282
1/25/2023 CompC Sales Val 38186.429
2/1/2023 CompC Sales Val 53816.169
2/2/2023 CompC Sales Val 7007.7672
2/3/2023 CompC Sales Val 8962.164
2/4/2023 CompC Sales Val 59355.153
2/5/2023 CompC Sales Val 72398.66
2/6/2023 CompC Sales Val 50443.206
2/7/2023 CompC Sales Val 29849.156
2/8/2023 CompC Sales Val 17709.52
2/9/2023 CompC Sales Val 34081.93
2/10/2023 CompC Sales Val 18113.762
2/11/2023 CompC Sales Val 56739.95
2/12/2023 CompC Sales Val 97214.452
2/13/2023 CompC Sales Val 24221.274
2/14/2023 CompC Sales Val 61048.183
2/15/2023 CompC Sales Val 24278.364
2/16/2023 CompC Sales Val 14294.869
2/17/2023 CompC Sales Val 68881.588
2/18/2023 CompC Sales Val 43360.136
2/19/2023 CompC Sales Val 47909.441
2/20/2023 CompC Sales Val 29371.623
2/21/2023 CompC Sales Val 41696.625
2/22/2023 CompC Sales Val 27121.565
2/23/2023 CompC Sales Val 24596.703
2/24/2023 CompC Sales Val 58967.855
2/25/2023 CompC Sales Val 1908.5052
3/1/2023 CompC Sales Val 77242.085
3/2/2023 CompC Sales Val 7680.6614
3/3/2023 CompC Sales Val 10913.527
3/4/2023 CompC Sales Val 2945.642
3/5/2023 CompC Sales Val 41895.223
3/6/2023 CompC Sales Val 22598.97
3/7/2023 CompC Sales Val 56334.887
 3/8/2023 CompC Sales Val 76499.583
3/9/2023 CompC Sales Val 94582.985
3/10/2023 CompC Sales Val 57210.007
3/11/2023 CompC Sales Val 138.10359
3/12/2023 CompC Sales Val 21576.181
3/13/2023 CompC Sales Val 47036.241
3/14/2023 CompC Sales Val 55707.235
3/15/2023 CompC Sales Val 58197.53
3/16/2023 CompC Sales Val 66208.37
3/17/2023 CompC Sales Val 7773.29
3/18/2023 CompC Sales Val 10990.514
3/19/2023 CompC Sales Val 43116.216
3/20/2023 CompC Sales Val 47751.988
3/21/2023 CompC Sales Val 95247.537
3/22/2023 CompC Sales Val 42628.006
3/23/2023 CompC Sales Val 54754.251
3/24/2023 CompC Sales Val 11262.803
3/25/2023 CompC Sales Val 9799.1222
4/1/2023 CompC Sales Val 777.04454
4/2/2023 CompC Sales Val 59369.035
4/3/2023 CompC Sales Val 35346.277
4/4/2023 CompC Sales Val 29006.068
4/5/2023 CompC Sales Val 84015.139
4/6/2023 CompC Sales Val 52457.947
4/7/2023 CompC Sales Val 8614.2429
4/8/2023 CompC Sales Val 733.59268
4/9/2023 CompC Sales Val 54595.95
4/10/2023 CompC Sales Val 8422.4347
4/11/2023 CompC Sales Val 72183.874
4/12/2023 CompC Sales Val 63814.875
4/13/2023 CompC Sales Val 80545.816
4/14/2023 CompC Sales Val 78292.72
4/15/2023 CompC Sales Val 5179.7183
4/16/2023 CompC Sales Val 38198.403
4/17/2023 CompC Sales Val 25644.746
4/18/2023 CompC Sales Val 96782.517
4/19/2023 CompC Sales Val 36566.011
4/20/2023 CompC Sales Val 63197.638
4/21/2023 CompC Sales Val 30301.66
4/22/2023 CompC Sales Val 53016.686
4/23/2023 CompC Sales Val 47151.912
4/24/2023 CompC Sales Val 37616.288
4/25/2023 CompC Sales Val 27904.407
1/1/2023 CompD Sales Val 62174.107
1/2/2023 CompD Sales Val 22640.18
1/3/2023 CompD Sales Val 92430.544
1/4/2023 CompD Sales Val 75933.817
 1/5/2023 CompD Sales Val 37986.379
1/6/2023 CompD Sales Val 22327.302
1/7/2023 CompD Sales Val 56741.876
1/8/2023 CompD Sales Val 4786
1/9/2023 CompD Sales Val 60279.437
1/10/2023 CompD Sales Val 51863.482
1/11/2023 CompD Sales Val 14432.079
1/12/2023 CompD Sales Val 64522.36
1/13/2023 CompD Sales Val 62754.037
1/14/2023 CompD Sales Val 695.64046
1/15/2023 CompD Sales Val 3950.7673
1/16/2023 CompD Sales Val 1657.9971
1/17/2023 CompD Sales Val 58752.296
1/18/2023 CompD Sales Val 58049.851
1/19/2023 CompD Sales Val 69636.283
1/20/2023 CompD Sales Val 72192.254
1/21/2023 CompD Sales Val 85313.486
1/22/2023 CompD Sales Val 18954.885
1/23/2023 CompD Sales Val 79082.375
1/24/2023 CompD Sales Val 14177.087
1/25/2023 CompD Sales Val 1048.3428
2/1/2023 CompD Sales Val 97251.512
2/2/2023 CompD Sales Val 62884.664
2/3/2023 CompD Sales Val 28175.974
2/4/2023 CompD Sales Val 9229.9635
2/5/2023 CompD Sales Val 79785.575
2/6/2023 CompD Sales Val 45203.191
2/7/2023 CompD Sales Val 61952.89
2/8/2023 CompD Sales Val 27352.421
2/9/2023 CompD Sales Val 87340.281
2/10/2023 CompD Sales Val 75962.242
2/11/2023 CompD Sales Val 57377.327
2/12/2023 CompD Sales Val 82992.719
2/13/2023 CompD Sales Val 578.46816
2/14/2023 CompD Sales Val 83360.864
2/15/2023 CompD Sales Val 43871.78
2/16/2023 CompD Sales Val 95236.531
2/17/2023 CompD Sales Val 50203.748
2/18/2023 CompD Sales Val 78123.108
2/19/2023 CompD Sales Val 28412.22
2/20/2023 CompD Sales Val 64076.398
2/21/2023 CompD Sales Val 67938.931
2/22/2023 CompD Sales Val 26122.124
2/23/2023 CompD Sales Val 62836.527
2/24/2023 CompD Sales Val 19686.651
2/25/2023 CompD Sales Val 24958.335
3/1/2023 CompD Sales Val 92337.032
 3/2/2023 CompD Sales Val 75340.725
3/3/2023 CompD Sales Val 69431.229
3/4/2023 CompD Sales Val 97976.212
3/5/2023 CompD Sales Val 64929.736
3/6/2023 CompD Sales Val 13413.195
3/7/2023 CompD Sales Val 95127.543
3/8/2023 CompD Sales Val 95806.275
3/9/2023 CompD Sales Val 71457.439
3/10/2023 CompD Sales Val 90413.824
3/11/2023 CompD Sales Val 33351.849
3/12/2023 CompD Sales Val 63120.708
3/13/2023 CompD Sales Val 73585.201
3/14/2023 CompD Sales Val 85382.968
3/15/2023 CompD Sales Val 94970.202
3/16/2023 CompD Sales Val 6678.3084
3/17/2023 CompD Sales Val 2413.5843
3/18/2023 CompD Sales Val 15407.824
3/19/2023 CompD Sales Val 24793.43
3/20/2023 CompD Sales Val 41513.113
3/21/2023 CompD Sales Val 2392.705
3/22/2023 CompD Sales Val 19439.711
3/23/2023 CompD Sales Val 39284.634
3/24/2023 CompD Sales Val 15383.954
3/25/2023 CompD Sales Val 77134.442
4/1/2023 CompD Sales Val 71949.089
4/2/2023 CompD Sales Val 27131.443
4/3/2023 CompD Sales Val 92127.309
4/4/2023 CompD Sales Val 80228.556
4/5/2023 CompD Sales Val 20020.111
4/6/2023 CompD Sales Val 22030.219
4/7/2023 CompD Sales Val 32210.241
4/8/2023 CompD Sales Val 89938.77
4/9/2023 CompD Sales Val 53175.444
4/10/2023 CompD Sales Val 20113.32
4/11/2023 CompD Sales Val 45094.601
4/12/2023 CompD Sales Val 65791.723
4/13/2023 CompD Sales Val 59396.667
4/14/2023 CompD Sales Val 24058.011
4/15/2023 CompD Sales Val 34789.583
4/16/2023 CompD Sales Val 47249.523
4/17/2023 CompD Sales Val 79075.226
4/18/2023 CompD Sales Val 77086.476
4/19/2023 CompD Sales Val 48354.348
4/20/2023 CompD Sales Val 89068.413
4/21/2023 CompD Sales Val 63157.209
4/22/2023 CompD Sales Val 89798.272
4/23/2023 CompD Sales Val 99373.257
4/24/2023 CompD Sales Val 66901.671
4/25/2023 CompD Sales Val 22113.843
 Month wise YTD Level Data for the given data.
YTD- Year to Date
YTD(Mar) = Jan + Feb +Mar
Also Calcu Growth(YTD)% = (This/Last) - 1

cted Output Sample

Metric YEAR Month YTD_VALUES

Sales Vol 2023 Jan <sum values for jan 2023>
Sales Vol 2023 Feb <sum values for jan+feb 2023>
Sales Vol 2023 Mar <sum values for jan+feb+mar 2023>
Sales Vol 2023 Apr <sum values for jan+feb+mar+apr 2023>
Sales Val 2023 Jan <sum values for jan 2023>
Sales Val 2023 Feb <sum values for jan+feb 2023>
Sales Val 2023 Mar <sum values for jan+feb+mar 2023>
Sales Val 2023 Apr <sum values for jan+feb+mar+apr 2023>
Sales Vol 2023 Jan <sum values for jan 2023>
Sales Vol 2023 Feb <sum values for jan+feb 2023>
Sales Vol 2023 Mar <sum values for jan+feb+mar 2023>
Sales Vol 2023 Apr <sum values for jan+feb+mar+apr 2023>
Sales Val 2023 Jan <sum values for jan 2023>
Sales Val 2023 Feb <sum values for jan+feb 2023>
Sales Val 2023 Mar <sum values for jan+feb+mar 2023>
Sales Val 2023 Apr <sum values for jan+feb+mar+apr 2023>

s) over(Partition by Company order by years rows between unbounded preceding and current row) as MTD from
ompany,Metric,Year(Period)as years,Month(Period) as months,sum(Sales_values) as sales from dbo.Book2$
Company,Metric,Month(Period),Year(Period))tb