show total by Office when selected using a slicer

[steve400243]

Hello, on this report, DATA Tab, I am having trouble showing the total by different Offices. I have put in a pivot table on the TABLE DATA Tab, and inserted a slicer to select the office.
How can I get the Data to populate to the cells, like Shown, when an office is selected on the Slicer? I have my desired results manually entered on the TABLE DATA Tab, and the FUSATL Office selected.

Thanks for all the help.

NEW CFS REPORT(2).xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
3	MBL	VESSEL	CONTAINER	HBL#	OFFICE	CUSTOMER	MODE	CARTONS	CBM	CUSTOMS RELEASE	OBL NOTIFICATION	ENTRY#	DO RECEIVED	P/U DATE	RELEASED TO	PRO#	SHIPPER PALLETS	FTN PALLETS	COMMENTS	WHSE FEE	STORAGE	TOTAL
4	HDMUTPEM58732000	SAN DIEGO BRIDGE	HDMU5523881	TPS000083445	FUSATL	COPPERMOON TM		428	17	9/12/2022	9/6/2022	799-0987175-8	8/30/2022	9/13/2022	FXF/FMM	724264853-4		12		$ 459.00	$ -	$ 459.00
5	SMLMSHSR2A382100	SM YANTIAN	SMCU1312690	SHS000258632	FUSATL	HERCULES SEALING PRODUCTS-USA		10	0.8	9/8/2022	8/22/2022	799-0797303-6	8/17/2022	9/8/2022	FXF	724265375-1		1		$ 21.60	$ 50.00	$ 71.60
6	SMLMSHSR2E421600	SM BUSAN	SMCU1052313	SHS000259614	FUSATL	MUELLER REFRIGERATION LLC	FMM	134	3.06	9/21/2022	9/13/2022	799-1190056-1	9/12/2022	9/22/2022	FXF/FMM	724264279-4	4			$ 82.62	$ -	$ 82.62
7	SMLMSHSR2E421600	SM BUSAN	SMCU1052313	SHS000259617	FUSATL	MUELLER REFRIGERATION LLC	FMM	32	1.16	9/15/2022	9/13/2022	799-1189797-3	9/12/2022	9/22/2022	FXF/FMM	724264278-3	1			$ 31.32	$ -	$ 31.32
8	YMLUW226309038	ONE MAGDALENA	TGBU7109730	SZS000183661	FUSATL	ICA SOUTH	FMM	15	0.645	8/31/2022	8/9/2022	799-0857166-5	8/9/2022	9/13/2022	FXF/FMM	724263598-2		1	8/31*HOLD*C.O.D. **ok to go out	$ 17.42	$ 117.73	$ 135.14
9	YMLUW232471446	HYUNDAI BRAVE	FFAU1389667	NGS000102309	FUSATL	KELVION	FMM	5	4.45	9/7/2022	8/18/2022	799-1055542-4	9/13/2022	9/19/2022	FXF	724264308-5		5		$ 120.15	$ -	$ 120.15
10	YMLUW236697021	HYUNDAI COURAGE	SEGU4435037	SHS000258104	FUSATL	MUELLER STREAMLINE CO	FMM	741	11.21	9/12/2022	8/18/2022	799-1094869-4	8/30/2022	9/13/2022	FXF/FMM	724264859-3	9			$ 302.67	$ 50.00	$ 352.67
11	YMLUW236697021	HYUNDAI COURAGE	SEGU4435037	SHS000258303	FUSATL	HERCULES SEALING PRODUCTS-USA	FMM	12	0.6	9/6/2022	9/7/2022	799-0982042-5	8/30/2022	9/8/2022	FXF/FMM	724264858-2		1		$ 16.20	$ -	$ 16.20
12	YMLUW236697022	HYUNDAI COURAGE	TEMU7623796	SHS000258299	FUSATL	MUELLER REFRIGERATION LLC	FMM	32	2.29	9/9/2022	9/9/2022	799-1094583-1	8/30/2022	9/12/2022	FXF/FMM	724264862-6		3		$ 61.83	$ -	$ 61.83
13	YMLUW236697022	HYUNDAI COURAGE	TEMU7623796	SHS000258448	FUSATL	LC KING MFG	FMM	24	2.6	9/16/2022	8/18/2022	79909841462	8/30/2022	9/19/2022	FXF/FMM	724264861-5		1		$ 70.20	$ 50.00	$ 120.20
14	YMLUW236700620	ATHOS	YMMU6312364	SHS000258567	FUSATL	HERCULES SEALING PRODUCTS-USA	FMM	3	1.89	9/16/2022	9/12/2022	79911916260	9/14/2022	9/21/2022	FXF/FMM	724264334-3	3			$ 51.03	$ -	$ 51.03
15	YMLUW236700620	ATHOS	YMMU6312364	SHS000258612	FUSATL	MUELLER REFRIGERATION LLC	FMM	83	4	9/15/2022	9/12/2022	799-1197947-4	9/13/2022	9/21/2022	FXF/FMM	724264314-4	5			$ 108.00	$ -	$ 108.00
16	YMLUW240296930	ONE COSMOS	SEGU5910234	QDS000054894	FUSATL	LINCOLN BRASS WORKS	FMM	17	1.2	8/25/2022	8/18/2022	799-0816164-9	8/19/2022	9/6/2022	FXF/FMM	724264742-5	1			$ 32.40	$ -	$ 32.40
17	CMDUHKA2247033	OOCL OAKLAND	TLLU4523789	HKS000078169	FUSBOS	EASTERN ACOUSTIC WORKS	FMM	31	6.089	9/14/2022	9/6/2022	799-0894219-6	8/24/2022	9/15/2022	FXF/FMM	724264779-0	3			$ 164.40	$ 50.00	$ 214.40
18	COSU6337189670	OOCL OAKLAND	CSNU6444851	HKS000078289	FUSBOS	AMERICAN RING CO INC		151	8.204	9/9/2022	8/25/2022	799-0890172-1	8/25/2022	9/9/2022	FXF	724264786-0		4		$ 221.51	$ -	$ 221.51
19	COSU6337189670	OOCL OAKLAND	CSNU6444851	HKS000078362	FUSBOS	PARAGON COMMUNICATIONS INC	FMM	65	2.2	8/26/2022	8/25/2022	799-0893863-2	8/25/2022	9/7/2022	FXF/FMM	724264784-5	1			$ 59.40	$ -	$ 59.40
20	COSU6340420190	EVER EAGLE	TCNU2295924	HKS000078224	FUSBOS	AMERICAN RING CO INC		276	12.371	9/12/2022	8/18/2022	799-0859915-2	8/23/2022	9/12/2022	FXF	724264758-0		6		$ 334.02	$ 136.60	$ 470.61
21	HDMUTPEM34111500	ONE THESEUS	HDMU5589425	TPS000083786	FUSBOS	DYMOTEK CORPORATION	FMM	720	3.45	9/27/2022	9/9/2022	799-1171548-0	9/12/2022	9/28/2022	FXF/FMM	724264288-6	6			$ 93.15	$ 50.00	$ 143.15
22	HDMUTPEM34111500	ONE THESEUS	HDMU5589425	TPS000083799	FUSBOS	FACTORY FIVE RACING INC	FMM	126	10.46	9/15/2022	9/9/2022	799-1218293-8	9/12/2022	9/22/2022	FXF	724264289-0	4			$ 282.42	$ -	$ 282.42
23	HDMUTPEM58283400	SAN FRANCISCO BRIDGE	HMMU5413579	TPS000083136	FUSBOS	EDSON MANUFACTURING INC.	FMM	212	4.44	9/20/2022	8/18/2022	799-0990361-9	8/17/2022	9/21/2022	FXF/FMM	724265368-1	6			$ 119.88	$ 609.44	$ 729.32
24	HDMUTPEM58283400	SAN FRANCISCO BRIDGE	HMMU5413579	TPS000083402	FUSBOS	KANGURU SOLUTIONS	FMM	120	8.09	9/7/2022	8/18/2022	799-0771823-3	8/18/2022	9/8/2022	FXF/FMM	724265390-2	3			$ 218.43	$ 333.15	$ 551.58
25	HDMUTPEM58283400	SAN FRANCISCO BRIDGE	HMMU5413579	TPS000083403	FUSBOS	KANGURU SOLUTIONS	FMM	48	1.52	9/1/2022	8/18/2022	799-0770947-1	8/18/2022	9/2/2022	FXF/FMM	724265391-3		1		$ 41.04	$ 50.00	$ 91.04
26	SMLMHKG2H9821700	SM BUSAN	CAIU9922745	SZS000184349	FUSBOS	AMERICAN RING CO INC	FMM	156	7.415	9/22/2022	9/9/2022	799-1008346-8	9/1/2022	9/23/2022	FXF/FMM	724264187-3		4		$ 200.21	$ -	$ 200.21
27	SMLMSHSR2A382100	SM YANTIAN	SMCU1312690	SHS000258258	FUSBOS	AMERICAN RING CO INC		36	2	9/8/2022	8/22/2022	799-0802986-1	8/18/2022	9/8/2022	FXF	724265403-1		2		$ 54.00	$ 50.00	$ 104.00
28	SMLMSHSR2A382100	SM YANTIAN	SMCU1312690	SHS000258565	FUSBOS	FACTORY FIVE RACING INC	FMM	2	2.5	9/15/2022	8/22/2022	799-0792580-4	8/17/2022	9/16/2022	FXF/FMM	724265376-2	2			$ 67.50	$ 137.50	$ 205.00
29	SMLMSHSR2E371300	SM LONG BEACH	CAIU4450311	SHS000259233	FUSBOS	VACUUM TECHNOLOGY INC		1	5.86	9/6/2022	9/6/2022	799-0896193-1	9/13/2022	9/15/2022	FXF	724264309-6	1			$ 158.22	$ -	$ 158.22
30	YMLUW226304647	SEASPAN BEACON	TGBU5550957	SZS000182821	FUSBOS	BREAS MEDICAL INC.	FMM	52	4.736	9/12/2022	8/8/2022	799-0797307-7	8/17/2022	9/26/2022	FXF/FMM	724265372-5	3		C.O.D. /9/23*OK to Release per Denise Armstrong	$ 127.87	$ 646.74	$ 774.61
31	YMLUW226311354	NAVIOS UNISON	TGBU5153219	SZS000183577	FUSBOS	DART WORLD INC	FMM	85	0.743	9/12/2022	8/18/2022	799-0805965-2	8/18/2022	9/13/2022	FXF/FMM	724265401-6		1		$ 20.06	$ 76.01	$ 96.07
32	YMLUW226314105	SEASPAN ZAMBEZI	FFAU1523631	SZS000183895	FUSBOS	EAW NORTH AMERICA INC	FMM	148	21.753	9/6/2022	9/2/2022	799-0779191-7	8/17/2022	9/7/2022	FXF/FMM	724265380-6		13		$ 587.33	$ -	$ 587.33
33	YMLUW226327361	YM TRUTH	CAIU7697521	SZS000184961	FUSBOS	AMERICAN RING CO INC	FMM	68	3.298	9/27/2022	9/15/2022	799-1256990-2	9/15/2022	9/29/2022	FMM	724264370-4		2		$ 89.05	$ -	$ 89.05
34	YMLUW232469977	MOL BENEFACTOR	YMMU4074647	NGS000101990	FUSBOS	INTERNATIONAL CONFIGURATIONS INC.	FMM	220	8	9/1/2022	8/18/2022	799-0860034-9	8/23/2022	9/8/2022	FXF/FMM	724264748-4		8		$ 216.00	$ -	$ 216.00
35	YMLUW232474503	SAN DIEGO BRIDGE	CAIU7966702	NGS000102932	FUSBOS	DAMASCUS WORLDWIDE	FMM	50	2.2	9/19/2022	9/27/2022	799-0890711-6	8/24/2022	9/26/2022	FXF/FMM	724264777-5		2		$ 59.40	$ 96.20	$ 155.60
36	YMLUW232474503	SAN DIEGO BRIDGE	CAIU7966702	NGS000102977	FUSBOS	COMMONWEALTH SOAP TOILETRIES	FMM	23	3.43	9/16/2022	9/6/2022	79908902927	8/24/2022	9/19/2022	FXF/FMM	724264319-2		2		$ 92.61	$ 50.00	$ 142.61
37	YMLUW232474503	SAN DIEGO BRIDGE	CAIU7966702	NGS000103045	FUSBOS	FACTORY FIVE RACING INC	FMM	59	5.225	9/15/2022	9/6/2022	799-0887409-2	8/24/2022	9/16/2022	FXF/FMM	724264778-6		3		$ 141.08	$ -	$ 141.08
38	YMLUW232475608	ONE THESEUS	DRYU9756840	NGS000103184	FUSBOS	INTERNATIONAL CONFIGURATIONS INC.	FMM	17	0.64	9/19/2022	9/9/2022	799-1215745-0	9/8/2022	9/21/2022	FXF/FMM	724264257-3		1		$ 17.28	$ -	$ 17.28
39	YMLUW232475608	ONE THESEUS	DRYU9756840	NGS000102903	FUSBOS	INTERNATIONAL CONFIGURATIONS INC.	FMM	409	11.63	9/20/2022	9/9/2022	799-1215593-4	9/8/2022	9/21/2022	FXF/FMM	724264258-4	9			$ 314.01	$ -	$ 314.01
40	YMLUW236692909	SEASPAN BEACON	SEGU5301557	SHS000257807	FUSBOS	BREAS MEDICAL INC.	FMM	2	3.384	9/1/2022	8/8/2022	799-0782990-7	8/17/2022	9/2/2022	FXF/FMM	724265369-2	2	C.O.D.		$ 91.37	$ 50.00	$ 141.37
41	YMLUW236692909	SEASPAN BEACON	SEGU5301557	SHS000257926	FUSBOS	INTERNATIONAL CONFIGURATIONS INC.	FMM	22	1.43	9/1/2022	8/26/2022	799-0784425-2	8/17/2022	9/2/2022	FXF/FMM	724265370-3		1		$ 38.61	$ 50.00	$ 88.61
42	YMLUW236695122	SEASPAN YANGTZE	YMLU8837790	SHS000257947	FUSBOS	VACUUM TECHNOLOGY INC		2	6.57	8/31/2022	8/18/2022	799-0873552-5	9/2/2022	9/2/2022	FXF	724264198-0	2		8/30*HOLD per Bobbie*9/2 OK to send out	$ 177.39	$ -	$ 177.39
43	YMLUW236697022	HYUNDAI COURAGE	TEMU7623796	SHS000257929	FUSBOS	AMERICAN RING CO INC		265	19.2	9/2/2022	9/2/2022	799-1006753-7	8/30/2022	9/13/2022	FXF	724264172-2		10		$ 518.40	$ -	$ 518.40
44	YMLUW236697022	HYUNDAI COURAGE	TEMU7623796	SHS000258426	FUSBOS	A-BOS LIMITED		259	4.26	9/1/2022	8/18/2022	799-1001643-5	8/30/2022	9/9/2022	FXF	724264173-3		3		$ 115.02	$ -	$ 115.02
45	YMLUW236700620	ATHOS	YMMU6312364	SHS000258993	FUSBOS	A-BOS LTD.	FMM	128	9.2	9/14/2022	9/12/2022	799-1208723-6	9/8/2022	9/21/2022	FXF/FMM	724264252-5		6		$ 248.40	$ -	$ 248.40
46	YMLUW240296930	ONE COSMOS	SEGU5910234	QDS000054871	FUSBOS	A-BOS LIMITED	FMM	42	2.55	8/26/2022	8/18/2022	799-0793724-7	8/17/2022	9/6/2022	FXF/FMM	724265362-2		2		$ 68.85	$ -	$ 68.85
47	YMLUW240296930	ONE COSMOS	SEGU5910234	QDS000054876	FUSBOS	A-BOS LIMITED	FMM	549	15.5	8/26/2022	8/25/2022	799-0793221-4	8/18/2022	9/6/2022	FXF/FMM	724265389-1	8			$ 418.50	$ -	$ 418.50
48	YMLUW302510517	SEASPAN BEACON	YMMU6368229	HKS000078019	FUSBOS	AMERICAN RING CO INC		745	36.127	9/6/2022	8/18/2022	799-0890983-1	8/25/2022	9/12/2022	FXF/FMM	724264783-4		17	HOLD**HOLD REMOVED	$ 975.43	$ 885.11	$ 1,860.54
49	YMLUW302510545	SEASPAN YANGTZE	YMMU6078976	HKS000078037	FUSBOS	BREAS MEDICAL INC.	FMM	25	0.768	9/1/2022	8/25/2022	799-0883460-9	8/23/2022	9/2/2022	FXF/FMM	724264762-4	1			$ 20.74	$ -	$ 20.74
50	YMLUW302510545	SEASPAN YANGTZE	YMMU6078976	HKS000078049	FUSBOS	AMERICAN RING CO INC		231	11.425	9/1/2022	8/25/2022	799-0859986-3	8/23/2022	9/1/2022	FXF	724264761-3		5		$ 308.48	$ -	$ 308.48
51	YMLUW302510708	HYUNDAI COURAGE	SEGU5358362	HKS000078190	FUSBOS	AMERICAN RING CO INC	FMM	707	31.716	9/12/2022	9/6/2022	799-1006336-1	8/30/2022	9/14/2022	FXF/FMM	724264307-4		13		$ 856.33	$ 111.01	$ 967.34
52	YMLUW302510991	YM TIPTOP	BMOU5687571	HKS000078347	FUSBOS	AMERICAN RING CO INC		487	24.678	9/13/2022	9/9/2022	799-1209564-3	9/8/2022	9/26/2022	FMM	724264913-1		12		$ 666.31	$ -	$ 666.31
DATA

NEW CFS REPORT(2).xlsm
	I	J	K	L	M	N	O	P	Q	R	S
1
2
3
4
5
6	Row Labels				OFFICE	HAWB	Whse Fee	Storage Fee	HBL Total
7	FUSATL				FUSATL	TPS000083445	$ 459.00	$ -	$ 459.00
8	Grand Total					SHS000258632	$ 21.60	$ 50.00	$ 71.60
9						SHS000259614	$ 82.62	$ -	$ 82.62
10						SHS000259617	$ 31.32	$ -	$ 31.32
11						SZS000183661	$ 17.42	$ 117.73	$ 135.14
12						NGS000102309	$ 120.15	$ -	$ 120.15
13						SHS000258104	$ 302.67	$ 50.00	$ 352.67
14						SHS000258303	$ 16.20	$ -	$ 16.20
15						SHS000258299	$ 61.83	$ -	$ 61.83
16						SHS000258448	$ 70.20	$ 50.00	$ 120.20
17						SHS000258567	$ 51.03	$ -	$ 51.03
18						SHS000258612	$ 108.00	$ -	$ 108.00
19						QDS000054894	$ 32.40	$ -	$ 32.40
20
21
22
23
24
25
26
27
28
29
30
31
32
33
TABLE DATA

 

[steve400243]

I am not needing this any longer. Going with a different option. Please disregard.