Pivot Table to Show only the items that are in Escalation

[Robert_Conklin]

Good evening,

I am building a supplier onboarding tracker in Excel and need a pivot table that shows only the supplier names (column F) using the data in column AG. Is this possible or is there an easier way?

SUPPLIER ONBOARDING (ROUND 2) TRACKER.xlsx
	A	B	C	D	E	F																											AG
2	VN	IP	ACM_ID	SM_ID - ARIBA	TILE SELECTION	SUPPLIER NAME																											TRR ESCALATION
3	0001077491	0001077491	ACM_10869103	S43053172		XEROX CORPORATION																											1
4	0001079135	0001079135	ACM_10868468	S43050499		ACOUSTIC-SCOTCH HOLDCO LP																											0
5	0001080263	0001080263	ACM_10866105	S43040962		ARDOQ INC																											0
6	0001063137	0001063137	ACM_10866136	S43040993		ASTUTE SOLUTIONS INC																											0
7	0001022038	0001022038	ACM_10866304	S43041757		BLUE YONDER INC																											0
SUPPLIER ONBOARING (ROUND 2)

Cell Formulas
Range	Formula
AG3:AG7	AG3	=IF(AND([@[TRR SENT]]="Yes",[@[TRR SEND DATE]]<(TODAY()-7),[@[TRR ACCEPTED]]="No",[@[TRR SENT2]]=1),1,0)

 

[Robert_Conklin]

I used a filter to resolve this inquiry.