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

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

Hi

Select the dropdown on the Row field Part DescriptionLabel
filtersContains ,SNA

I would use the comma in front of SNA, so you don't pick up items which
might be Snap Binders for example (should such a description exist)

The Row icon will have a filter icon against it. When you want to clear the
filter, click the dropdown again and choose Clear Filter.
--
Regards
Roger Govier



"snax500" wrote in message
ups.com...
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

Label filters is greyed out.

On Nov 7, 4:45 pm, "Roger Govier" <rogerattechnology4NOSPAMu.co.uk
wrote:
Hi

Select the dropdown on the Row field Part DescriptionLabel
filtersContains ,SNA

I would use the comma in front of SNA, so you don't pick up items which
might be Snap Binders for example (should such a description exist)

The Row icon will have a filter icon against it. When you want to clear the
filter, click the dropdown again and choose Clear Filter.
--
Regards
Roger Govier

"snax500" wrote in message

ups.com...



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- Hide quoted text -

- Show quoted text -