Single Excel pivot table slicer for multiple fields

Is it possible to have a slicer that will select all records with a particular value in a range of columns?

For example, suppose I have a table of students and their subject preferences. The pivot table might show the number of students at each school. Can I then have a slicer that will show me just the students who have chosen Math as any of their preferences?
My actual file has many more columns, rows, and options for subject, but this example illustrates what I'm trying to do.

Thank you.
Ben TurnerData AnalystAsked:
Who is Participating?
abbas abdullaConnect With a Mentor Commented:
Hi Ben,

You should add helper column data to find out what are you searching for, since your data are in multiple columns and filter/slicer can be applied to one column only. See the attached example i made for you. Change the filter value from L1 Cell then Refresh the pivot table to get fresh data.

Abbas Abdulla
It's easy for us to get your example file.
Ben TurnerConnect With a Mentor Data AnalystAuthor Commented:
Hi Abbas Abdulla,

I did come up with something similar to your method, although I didn't use a table.

The actual file I want to use this for has over 400,000 rows, and is about 200MB, so I wanted to have the pivot tables in a different file to the data table. Using the helper column method means I have to have both files open to do the calculation, which is a bit slow, but I will probably just have to put up with that. Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.