Avatar of Ben Turner
Ben Turner
 asked on

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.
* slicers* Pivot TablesMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Ben Turner

8/22/2022 - Mon
OddyWriter

It's easy for us to get your example file.
ASKER CERTIFIED SOLUTION
abbas abdulla

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Ben Turner

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck