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.