Scuba
12-12-2023, 08:06 AM
Hello,
I have a pivot table set up (see below), with slicers for the Year & Month & mode, when the user selects a given Year, Month & Mode, I can extract the data no problem for a single Month, however, if the user selects more than one month at the same time, I am stuck.
For example if the user selects Year 2022, Month Feb & Mode Air, I can can easily extract 886294.3 as the correct value, however, if the user selects Feb & Apr, I do not know who to extract multiple points of data and then combine the values together for reporting.
Is anyone able to help, enlighten me on what I could do here?
Pivot table below:
Sum of Noatum Inv. CHATIL GBP
Mode
Year
Month Name
Air
Ocean
Sea-Air
Truck
Grand Total
2022
Jan
1251994.16
249490.16
54451.53
1555935.85
Feb
886294.3
346610.44
95834.21
1328738.95
Mar
1335004.59
212888.38
104424.86
1652317.83
Apr
1202239.53
241842.563
113192.62
1557274.713
May
1185394.11
241986.497
14302.57
119249.93
1560933.107
Jun
2095730.65
92167.3
93832.86
2281730.81
Jul
2460308.62
115627.68
128940.95
2704877.25
Aug
1756212.9
361831.4
145028.28
2263072.58
Sep
2019019.31
313097.22
106768.87
2438885.4
Oct
849161.31
226330.04
168454.7
1243946.05
Nov
1181327.36
790491.3967
170129.83
2141948.587
Dec
732611.01
961748.1333
131032.98
1825392.123
2022 Total
16955297.85
4154111.21
14302.57
1431341.62
22555053.25
2023
Jan
248257.31
1205177.603
158167.53
1611602.443
Feb
771581.28
737627.733
288040.88
1797249.893
Mar
549326.48
972323.1638
307490.33
1829139.974
Apr
172893.52
1015375.184
197668.71
1385937.414
May
271808.58
705721.9176
141897.77
1119428.268
Jun
260812.31
638372.8668
162893.47
1062078.647
Jul
321144.62
568981.7019
160842.44
1050968.762
Aug
305352.89
264738.5799
177473.87
747565.3399
Sep
55753.59
337369.5334
207111.57
600234.6934
Oct
178495.6
320089.1467
157216.8
655801.5467
Nov
95417.76
214326.03
112625.95
422369.74
2023 Total
3230843.94
6980103.46
2071429.32
12282376.72
Grand Total
20186141.79
11134214.67
14302.57
3502770.94
34837429.97
Thank you.
I have a pivot table set up (see below), with slicers for the Year & Month & mode, when the user selects a given Year, Month & Mode, I can extract the data no problem for a single Month, however, if the user selects more than one month at the same time, I am stuck.
For example if the user selects Year 2022, Month Feb & Mode Air, I can can easily extract 886294.3 as the correct value, however, if the user selects Feb & Apr, I do not know who to extract multiple points of data and then combine the values together for reporting.
Is anyone able to help, enlighten me on what I could do here?
Pivot table below:
Sum of Noatum Inv. CHATIL GBP
Mode
Year
Month Name
Air
Ocean
Sea-Air
Truck
Grand Total
2022
Jan
1251994.16
249490.16
54451.53
1555935.85
Feb
886294.3
346610.44
95834.21
1328738.95
Mar
1335004.59
212888.38
104424.86
1652317.83
Apr
1202239.53
241842.563
113192.62
1557274.713
May
1185394.11
241986.497
14302.57
119249.93
1560933.107
Jun
2095730.65
92167.3
93832.86
2281730.81
Jul
2460308.62
115627.68
128940.95
2704877.25
Aug
1756212.9
361831.4
145028.28
2263072.58
Sep
2019019.31
313097.22
106768.87
2438885.4
Oct
849161.31
226330.04
168454.7
1243946.05
Nov
1181327.36
790491.3967
170129.83
2141948.587
Dec
732611.01
961748.1333
131032.98
1825392.123
2022 Total
16955297.85
4154111.21
14302.57
1431341.62
22555053.25
2023
Jan
248257.31
1205177.603
158167.53
1611602.443
Feb
771581.28
737627.733
288040.88
1797249.893
Mar
549326.48
972323.1638
307490.33
1829139.974
Apr
172893.52
1015375.184
197668.71
1385937.414
May
271808.58
705721.9176
141897.77
1119428.268
Jun
260812.31
638372.8668
162893.47
1062078.647
Jul
321144.62
568981.7019
160842.44
1050968.762
Aug
305352.89
264738.5799
177473.87
747565.3399
Sep
55753.59
337369.5334
207111.57
600234.6934
Oct
178495.6
320089.1467
157216.8
655801.5467
Nov
95417.76
214326.03
112625.95
422369.74
2023 Total
3230843.94
6980103.46
2071429.32
12282376.72
Grand Total
20186141.79
11134214.67
14302.57
3502770.94
34837429.97
Thank you.