Pivot table slicer day total question

[steve400243]

Hello, I'm trying to put together this workbook with pivot table slicers on "Sheet3". I want the Day Total Slicer to be the sum total by Day and I cant figure out how to get it done. Thanks for any help provided.

Montague April - 2022a.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2
3	Row Labels
4	4/1/2022
5	5.67
6	7.87
7	8.25
8	10.07
9	14.85
10	Grand Total
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
Sheet3

Montague April - 2022a.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1									$ 3.85	$ 1.82	$ 2.20
2	Order Number	Order Date	Sales Order	Tracking	Ship Date	Purchase Order	Shipped To	State	Order Charge	Full Cartons Out	Unit Picks	Pallets Out	Day Total
3	2973688	4/27/2022	97218	0	4/28/2022	PHONE-PERKIOMEN	PERKIOMEN BICYCLES	PA	$ 3.85	1			$ 5.67
4	2973531	4/27/2022	97234	563483721643	4/28/2022	WOO # 85901	JONATHAN XU	CA	$ 3.85	1			$ 5.67
5	2973516	4/27/2022	97227	563483721654	4/28/2022	WOO # 85896	MY PHAM	CA	$ 3.85	1	1		$ 7.87
6	2973529	4/27/2022	97232	563483721665	4/28/2022	WOO # 85899	CHASE SMITH	TX	$ 3.85	1			$ 5.67
7	2973519	4/27/2022	97228	563483721676	4/28/2022	WOO # 85895	JOSE MAZARIEGO	NY	$ 3.85	1			$ 5.67
8	2973678	4/27/2022	97224	563483721687	4/28/2022	EMAIL-RUDY S CYCLE	RUDY S CYCLE FITNESS	IL	$ 3.85	1			$ 5.67
9	2973679	4/27/2022	97230	563483721698, 563483721702	4/28/2022	EMAIL-BIKE CRAZE STO	BIKE CRAZE	CA	$ 3.85	2			$ 7.49
10	2973530	4/27/2022	97233	563483721713	4/28/2022	WOO # 85900	OLIVIA HODGE	NY	$ 3.85	1			$ 5.67
11	2973687	4/27/2022	97215	563483721724	4/28/2022	6352 URBAN BICYCLE	URBAN BICYCLE GALLERY	TX	$ 3.85	1	1		$ 7.87
12	2973682	4/27/2022	97231	563483721735	4/28/2022	EMAIL-BIKE CRAZE	PHOTO DIAGNOSTIC SYSTEMS INC.	MA	$ 3.85	1	1		$ 7.87
13	2973533	4/27/2022	97206	563483721746	4/28/2022	PHONE-ATKINS BICYCLE	ATKINS BICYCLES	WI	$ 3.85	1	2		$ 10.07
14	2973677	4/27/2022	97226	563483721757	4/28/2022	PHONE-THE BIKE STAND	THE BIKE STAND	NJ	$ 3.85	1	2		$ 10.07
15	2962528	3/31/2022	97157	563483720810	4/1/2022	WOO # 85834	JESSIAH PAUL	SD	$ 3.85	1	1		$ 7.87
16	2962534	3/31/2022	97154	0	4/1/2022	D349680 IRWIN INT L	MT AIR LLC	CO	$ 3.85	1			$ 5.67
17	2962545	3/31/2022	97156	0	4/1/2022	D344306	GUSTAV C JAMISON	NC	$ 3.85	1	2		$ 10.07
18	2962510	3/31/2022	97126	563483720820	4/1/2022	PHONE-RIDE THIS BIKE	RIDE THIS BIKE	LA	$ 3.85	1			$ 5.67
19	2962514	3/31/2022	97148	563483720831	4/1/2022	WOO # 85829	THINH LE	CA	$ 3.85	1	1		$ 7.87
20	2962516	3/31/2022	97149	563483720842	4/1/2022	WOO # 85830	FRITZ KEINERT	IA	$ 3.85	1	2		$ 10.07
21	2962518	3/31/2022	97151	563483720853	4/1/2022	WOO # 85832	SHAWN WRIGHT	OK	$ 3.85	1	2		$ 10.07
22	2962519	3/31/2022	97152	563483720864	4/1/2022	WOO # 85833	ALLISON LAMANNA	MA	$ 3.85	1			$ 5.67
23	2962524	3/31/2022	97153	563483720875	4/1/2022	PHONE-FOX	ERIC FOX	IN	$ 3.85	1	1		$ 7.87
24	2962530	3/31/2022	97158	563483720886	4/1/2022	PHONE- RINES	ELECTRIC SPINZ	FL	$ 3.85	1	2		$ 10.07
25	2962511	3/31/2022	97147	563483720897	4/1/2022	WOO # 85824	MAGIC CYCLES	NC	$ 3.85	1	2		$ 10.07
26	2962544	3/31/2022	97155	0	4/1/2022	787148 IRWIN	IRWIN INTL	GA	$ 3.85		5		$ 14.85
27	2962631	3/31/2022	97159	563483720912	4/1/2022	WOO # 85836	GREG CRANHAM	CA	$ 3.85		2		$ 8.25
28	2963768	4/4/2022	97167	563483720923	4/6/2022	WOO # 85850	JAMES FUTIA	NJ	$ 3.85	1			$ 5.67
29	2963733	4/4/2022	97164	563483720934	4/6/2022	WOO # 85847	KE TANG	OK	$ 3.85	1			$ 5.67
30	2963729	4/4/2022	97161	563483720945	4/6/2022	WOO # 85844	HO LUN NG	CA	$ 3.85	1	3		$ 12.27
31	2963726	4/4/2022	97128	563483720967, 563483720978, 563483720989	4/6/2022	EMAIL-SUNRISE CYCLE	SUNRISE CYCLERY	UT	$ 3.85	3	6		$ 22.51
32	2963769	4/4/2022	97168	563483720956	4/6/2022	PHONE-BRUNO	TRUCKEE TAHOE AIRPORT WAREHOUSE	CA	$ 3.85	1	2		$ 10.07
33	2963730	4/4/2022	97162	563483720990	4/6/2022	WOO # 85845	ALLAN PARGMAN	MO	$ 3.85		2		$ 8.25
34	2963732	4/4/2022	97163	563483721003	4/6/2022	WOO # 85846	ANDY MAENDL	MT	$ 3.85		1		$ 6.05
35	Total								32	31	41	0	$ 269.82
Data

Cell Formulas
Range	Formula
C3:C34	C3	=VLOOKUP(Data!$A3,Sheet2!$A$1:$F$200,2,FALSE)
D3:D34	D3	=VLOOKUP(Data!$A3,Sheet2!$A$1:$F$200,3,FALSE)
F3:F34	F3	=VLOOKUP(Data!$A3,Sheet2!$A$1:$F$200,4,FALSE)
G3:G34	G3	=VLOOKUP(Data!$A3,Sheet2!$A$1:$F$200,5,FALSE)
H3:H34	H3	=VLOOKUP(Data!$A3,Sheet2!$A$1:$F$200,6,FALSE)
I3:I34	I3	=IF(Data!$A3>1,3.85,"0")
M3:M34	M3	=I3+$J$1*J3+$K$1*K3
I35	I35	=SUBTOTAL(103,[Order Charge])
J35	J35	=SUBTOTAL(109,[Full Cartons Out])
K35	K35	=SUBTOTAL(109,[Unit Picks])
L35	L35	=SUBTOTAL(109,[Pallets Out])
M35	M35	=SUBTOTAL(109,[Day Total])

Named Ranges
Name	Refers To	Cells
Refs	=Data!$A$3:$A$34	F3:I3, C3:D3

 

[GraH]

Seems you put your values (Day Total) in the row section. Put it in the value section of your pivot.

 

[steve400243]

Thank you GraH, will look at it when I get some extra time. Appreciate you following up on this. I will mark as solved and repost if I need More assistance.