ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Sales AgentPeriodSales Amount
Desired Output
3
Agent A12/31/20161,927.51
4
Agent A12/31/20171,334.68
Sum of Sales (All Agents) by years and current month
5
Agent A12/31/20181,292.87
latest month (based on Slicer Selection)
6
Agent A1/31/20191,225.21Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23Feb-24
7
Agent A10/31/20191,286.714,143.073,979.194,281.823,692.833,997.984,152.473,804.763,691.61629.00
8
Agent A11/30/2019931.64
9
Agent A12/31/2019930.69
10
Agent A1/31/2020946.26
11
Agent A2/29/2020835.73
12
Agent A3/31/2020945.13
13
Agent A4/30/2020944.60
14
Agent A5/31/2020944.03
15
Agent A6/30/2020941.95
16
Agent A7/31/2020941.65
17
Agent A8/31/2020940.34
18
Agent A9/30/2020940.14
19
Agent A10/31/2020940.89
20
Agent A11/30/2020940.40
21
Agent A12/31/2020863.79
22
Agent A1/31/2021915.64
23
Agent A2/28/2021915.79
24
Agent A3/31/2021917.57
25
Agent A4/30/2021917.92
26
Agent A5/31/2021919.27
27
Agent A6/30/2021918.53
28
Agent A7/31/2021917.39
29
Agent A8/31/2021916.04
30
Agent A9/30/2021915.63
31
Agent A10/31/2021914.20
32
Agent A11/30/2021912.89
33
Agent A12/31/20211,054.21
34
Agent A1/31/20221,054.52
35
Agent A2/28/20221,051.73
36
Agent A3/31/20221,051.37
37
Agent A4/30/20221,050.02
38
Agent A5/31/20221,048.48
39
Agent A6/30/2022786.07
40
Agent A7/31/2022791.66
41
Agent A8/31/2022790.88
42
Agent A9/30/2022789.77
43
Agent A10/31/2022788.65
44
Agent A11/30/2022788.08
45
Agent A12/31/2022687.27
46
Agent A1/31/2023689.08
47
Agent A2/28/2023687.42
48
Agent A3/31/2023686.60
49
Agent A4/30/2023682.31
50
Agent A5/31/2023682.60
51
Agent A6/30/2023681.69
52
Agent A7/31/2023682.32
53
Agent A8/31/2023681.60
54
Agent A9/30/2023680.60
55
Agent A10/31/2023680.33
56
Agent A11/30/2023678.94
57
Agent A12/31/2023639.72
58
Agent A1/31/2024639.28
59
Agent A12/31/2016354.02
60
Agent A12/31/2017350.54
61
Agent A12/31/2018346.41
62
Agent A1/31/2019278.95
63
Agent A10/31/2019335.76
64
Agent A11/30/2019335.37
65
Agent A12/31/2019295.88
66
Agent A1/31/2020278.95
67
Agent A2/29/2020278.61
68
Agent A3/31/2020278.26
69
Agent A4/30/2020277.92
70
Agent A5/31/2020277.60
71
Agent A6/30/2020277.23
72
Agent A7/31/2020276.89
73
Agent A8/31/2020276.47
74
Agent A9/30/2020259.09
75
Agent A10/31/2020258.83
76
Agent A11/30/2020258.58
77
Agent A12/31/2020258.33
78
Agent A1/31/2021205.14
79
Agent A2/28/2021205.02
80
Agent A3/31/2021173.25
81
Agent A4/30/2021173.15
82
Agent A5/31/2021173.05
83
Agent A6/30/2021172.95
84
Agent A7/31/2021173.04
85
Agent A8/31/2021173.12
86
Agent A9/30/2021173.02
87
Agent A10/31/2021172.92
88
Agent A11/30/2021172.86
89
Agent A12/31/2021173.09
90
Agent A1/31/2022172.99
91
Agent A2/28/2022173.78
92
Agent A3/31/2022174.04
93
Agent A4/30/2022174.30
94
Agent A5/31/2022174.66
95
Agent A6/30/2022175.48
96
Agent A7/31/2022175.37
97
Agent A8/31/2022175.72
98
Agent A9/30/2022176.03
99
Agent A10/31/2022175.92
100
Agent A11/30/2022176.30