Link to home
Create AccountLog in
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?
User generated image
My actual file has many more columns, rows, and options for subject, but this example illustrates what I'm trying to do.

Thank you.
Avatar of OddyWriter
OddyWriter
Flag of Thailand image

It's easy for us to get your example file.
ASKER CERTIFIED SOLUTION
Avatar of abbas abdulla
abbas abdulla
Flag of Bahrain image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account