Creating pivot table from two sources - I'm not sure how to use data from one of the tables

[hassan44]

Apologies for the vague title, brains a little fried from tying to think of an answer to this.

I have a pivot table that is calculating savings per area and within that, the names:

View attachment 106807

It is calculating the savings from the savings sheet

tester.xlsx
	A	B	C	D	E		G	H	I
4	area	name	contact 1	Contact2	RAG Status		Interest (High, Medium Low)	savings	Using contract
5	NCL	Darian Ross					High	£234,232.00	Yes
6	NCL	Mia Jefferson					High	n/a	No
7	NCL	Walter George					High	n/a	No
8	NCL	Clara Mcknight					High	n/a	No
9	NCL	Kadyn Boone					High	n/a	No
10	NCL	Elise Ford					High	£4,379,567.87	Yes
11	NCL	Brittany Villa					High	n/a	No
12	NCL	Israel Summers					High	n/a	No
13	NCL	Linda Keller					High	n/a	No
14	NCL	Allen Ford					High	nil	Yes
15	NEL	Larry Benton					High	n/a	No
16	NEL	Darrell Palmer					Low	£4,008,541.32	Yes
17	NEL	Fatima Melendez					Low	n/a	No
18	NEL	Aubrey Campbell					High	£4,034,738.62	Yes
19	NEL	Tyler Acevedo					High	£314,340.53	Yes
20	NWL	Kaiya Moody					High	nil	Yes
21	NWL	Amare Patel					Low	n/a	No
22	NWL	Paxton Dawson					High	nil	Yes
23	NWL	Aliza Santos					High	nil	Yes
24	NWL	Addison Phillips					High	n/a	No
25	NWL	Cristopher Mcpherson					High	nil	Yes
26	NWL	Reed Herrera					High	n/a	No
27	NWL	Makai Curry					High	n/a	No
28	SEL	Jocelyn Herman					Medium	n/a	No
29	SEL	Ann Schwartz					Medium	n/a	No
30	SEL	Jessie Mcpherson					Medium	n/a	No
31	SEL	Serenity Hinton					Medium	n/a	No
32	SEL	Valentino Colon					Medium	n/a	No
33	SEL	Eduardo Navarro					Medium	nil	Yes
34	SEL	Scarlet Jennings					Medium	n/a	No
35	SWL	Vaughn Mckay					High	£404,387.78	Yes
36	SWL	Emelia Mckenzie					High	nil	Yes
37	SWL	Xiomara Sanchez					High	nil	Yes
38	SWL	Kailyn Petersen					High	nil	Yes
39	SWL	Jordan York					High	nil	Yes
40	SWL	John Smith					High	n/a	No
Saving Sheet

I also have a name overview sheet.

tester.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
16		Name	1A	1B	1C	1D	1E	2A	2B	3A	3B	3C	S2S
17	NCL	Darian Ross	Red	Red	Red	Amber	Red	Red	Red	Red	Red	Amber	Red
18		Mia Jefferson	Red	Red	Red	Red	Amber	Red	Red	Red	Red	Red	Red
19		Walter George	Red	Red	Red	Red	Red	Red	Amber	Red	Red	Red	Red
20		Clara Mcknight	Amber	Amber	Amber	Red	Red	Amber	Red	Amber	Amber	Red	Amber
21		Kadyn Boone	Red	Red	Red	Red	Red	Red	Red	Red	Red	Red	Amber
22		Elise Ford	Red	Red	Red	Green	Red	Red	Red	Red	Red	Green	Red
23		Brittany Villa	Red	Red	Red	Red	Green	Red	Red	Red	Red	Red	Red
24		Israel Summers	Red	Red	Red	Amber	Red	Red	Green	Red	Red	Amber	Red
25		Linda Keller	Green	Green	Green	Green	Amber	Green	Red	Green	Green	Green	Red
26		Allen Ford	Red	Red	Red	Red	Green	Red	Amber	Red	Red	Red	Green
27	NEL	Larry Benton	Amber	Amber	Amber	Red	Red	Amber	Green	Amber	Amber	Red	Red
28		Darrell Palmer	Green	Green	Green	Green	Red	Green	Red	Green	Green	Green	Amber
29		Fatima Melendez	Red	Red	Red	Red	Amber	Red	Red	Red	Red	Red	Green
30		Aubrey Campbell	Red	Red	Red	Red	Red	Red	Green	Red	Red	Red	Red
31		Tyler Acevedo	Green	Green	Green	Red	Red	Green	Red	Green	Green	Red	Red
32	NWL	Kaiya Moody	Red	Red	Red	Green	Red	Red	Red	Red	Red	Green	Green
33		Amare Patel	Red	Red	Red	Red	Red	Red	Red	Red	Red	Red	Red
34		Paxton Dawson	Red	Red	Red	Red	Green	Red	Green	Red	Red	Red	Red
35		Aliza Santos	Green	Green	Green	Amber	Red	Green	Red	Green	Green	Amber	Red
36		Addison Phillips	Red	Red	Red	Red	Amber	Red	Red	Red	Red	Red	Green
37		Cristopher Mcpherson	Red	Red	Red	Red	Green	Red	Amber	Red	Red	Red	Red
38		Reed Herrera	Amber	Amber	Amber	Red	Red	Amber	Red	Amber	Amber	Red	Red
39		Makai Curry	Red	Red	Red	Green	Red	Red	Red	Red	Red	Green	Amber
40	SEL	Jocelyn Herman	Red	Red	Red	Green	Green	Red	Red	Red	Red	Green	Red
41		Ann Schwartz	Red	Red	Red	Red	Red	Red	Green	Red	Red	Red	Red
42		Jessie Mcpherson	Green	Green	Green	Red	Red	Green	Green	Green	Green	Red	Red
43		Serenity Hinton	Green	Green	Green	Red	Red	Green	Red	Green	Green	Red	Green
44		Valentino Colon	Red	Red	Red	Amber	Green	Red	Red	Red	Red	Amber	Green
45		Eduardo Navarro	Red	Red	Red	Amber	Red	Red	Red	Red	Red	Amber	Red
46		Scarlet Jennings	Red	Red	Red	Red	Red	Red	Amber	Red	Red	Red	Red
47	SWL	Vaughn Mckay	Amber	Amber	Amber	Green	Amber	Amber	Amber	Amber	Amber	Green	Red
48		Emelia Mckenzie	Amber	Amber	Amber	Red	Red	Amber	Red	Amber	Amber	Red	Amber
49		Xiomara Sanchez	Red	Red	Red	Green	Red	Red	Green	Red	Red	Green	Amber
50		Kailyn Petersen	Green	Green	Green	Green	Red	Green	Red	Green	Green	Green	Red
51		Jordan York	Red	Red	Red	Red	Green	Red	Green	Red	Red	Red	Green
52		John Smith	Green	Green	Green	Green	Green	Green	Green	Green	Green	Green	Red
name overview

If I click the Green slicer in the first picture. I want, under elise ford "1D"and "3C" to appear, Israel summers "2B", etc.



Is this possible? I feel like I know the answer somewhere in my mind I'm just not connecting the dots.

 

[hassan44]

just to add these names are fake, generated from automatic name generator

 

[hassan44]

I can't edit my posts, sorry guy not sure what's wrong time for bed i think. Here's the image that's meant to be attached

 

[hassan44]

I solved it, had to create a new table that was pivot table friendly with all the data in one.