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.