Can you make slicer with contains "X"

[scartruck]

Example data set: Artwork. Each row represents one artwork. One column represents the colors found in that piece. Colors are not mutually exclusive, so this column would look something like (R=red,O=orange,Y=yellow,G=green,B=blue,P=purple,0=black,1=white):

R01
RYG1
GB
Y
P01
ROYGB01

Can I make a slicer for my pivot table that would select all rows that contain "R"? Or something similar functionally. The default slicer has each unique combination and is not helpful. I tried creating a separate column for each color, and then you can filter by the columns one at a time which is fine for me, but I'm trying to make it look pretty for customers.

 

[mrmmickle1]

scartruck,

Welcome to the board!

The short answer is No.

Slicers are related to entire columns of data. In order to achieve your result you will need to reformat your data to contain True/False Flags for each color....

Excel 2010
	A	B	C	D	E	F	G	H
1	Artwork	R	Y	G	B	P	B	W
2	Name Here	TRUE	FALSE	TRUE	FALSE	TRUE	TRUE	FALSE
Sheet1