Combine Slicers in Pivot Table

[blrhode]

Hello,

I have a fairly simple data table that I've easily turned into a Pivot table, but when going to add the only slicer I need, I'm not able to get all data into one slicer. My example is below. There are other columns such as dollars, etc, that I have not included in the example. What I am trying to do is create one slicer with all competencies listed so that as I choose a competency, it will only show those customers using that particular competency. Is this possible? Any help is much appreciated!

Customer	Competency 1	Competency 2	Competency 3	Competency 4	Competency 5	Competency 6	Competency 7
Customer 1	x	x	x		x	x	x
Customer 2		x	x	x	x
Customer 3	x	x			x	x	x
Customer 4	x			x		x
Customer 5		x	x		x		x
Customer 6	x		x	x	x	x
Customer 7	x	x	x	x	x	x	x
Customer 8	x	x	x	x
Customer 9				x	x	x	x

<tbody>
</tbody>

 

[mrshl9898]

Is the issue when you select Competency 1, it shows all customers whether or not there is an x in there?

If so, add another slicer for the value with x selected

 

[blrhode]

The issue is I'm trying to add one slicer with all competencies listed. Instead I'm having to add 7 individual slicers, one with each competency.

 

[mrshl9898]

So the example is the data and not the pivot then?

Data needs to be like this in the table, 3 columns

Customer 1 Competancy 1 x
Customer 1 Competancy 2 x
Customer 1 Competancy 3 x
Customer 1 Competancy 4

etc...

Then pivoted to what you have provided as an example.

 

[blrhode]

Thank you, I will try that.

So the example is the data and not the pivot then?

Data needs to be like this in the table, 3 columns

Customer 1 Competancy 1 x
Customer 1 Competancy 2 x
Customer 1 Competancy 3 x
Customer 1 Competancy 4

etc...

Then pivoted to what you have provided as an example.