You can not do that directly. You need to add a helper column to your source
data that determines if the desired text string exists in the part number.
You can then add that field to the filter section of your pivot table. Reply
back if you need help with that...
--
HTH...

Jim Thomlinson


"snax500" wrote:

In Excel2007, I have a pivot that I want to filter ( like when you use
Autofilter in a list). I want to use the option "Contains". For
example, I have the follwong data in a pivot ( this is a small
sample):

PART DESCRIPTION Total
490936,PASTEL COLORED COPY GREENPG361 8.08
199909,SNAPG1880WIRE TRAYS 0
385747,ACC38610,LARGE DOODED CUPPG172 1.05
416701,SNA,DUST OFF,PG554, 2.88
493024,SNAPG735COMP LAMPASYMETIC LAMP 43.53
507032,SNA CLEAR MAGNETIC LABEL HOLDERS 28.14
604649,SNA JUMBO MESH MAGAZINE FILE 18.58
6333352,SNAPG554,DUST OFF10ONZ 6.63
827857,SNA PG172,PECILCUP2007CAT 1.47
010109 SNA ACC38610,ENCY,PRESSTEX RING BINDERS 13.6
010109,SNA ACC3861,ENCY RING BINDER YELLOW 3.44
010109,SNA ACC38610,ENCT PRESSTEX RING 141.04
010109,SNA ACC38610,ENCY PRESSTEX RING BINDERS 272
010109,SNA ACC38610,ENCYPRESSTEX RING BINDERS Y 54.4
138537,SNA,BINDER RING 8 1/2X11 BLACK 1.34
19909,PG188 WIRE LETTER TRAYS 0
370843,RSVP BALLPOINT PENS MED1.0 BLUE TRAN 6.14
385550,SNA ACC38610,ONLINE 4PK BIC WITE OUT COR 6.73
388736,SNA STACKING POST FOR LEGAL SIZE STACKIN 16.38
416701,SNA PG554,DUST OFF DISP DUSTERS,10 OZ 2.88
416701,SNA PG554,DUST-OFF DIPOSABLE DUSTER 2.88
423889,SNA ONLINE FELOWES PANTITION COAT HOOK 7.14

Is there a way to now filter this by if the Part Description contains
"SNA"?

Thanks