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?
Example
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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

OddyWriterMr.Commented:
It's easy for us to get your example file.
0
abbas abdullaCommented:
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.

Br,
Abbas Abdulla
EE-Slicer-PVT-Helper-Column.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ben TurnerData AnalystAuthor Commented:
Hi Abbas Abdulla,

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

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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
slicers

From novice to tech pro — start learning today.