Forum Discussion
Gerard Nelson
Sep 28, 2018Copper Contributor
Table slicer (not pivot table) with selection from a cell value
I have a table full of rows of data about assets. every asset is owner by a Manager. I can easily put a slicer on the table to allow the Manager to see their data. But there are over 350 Managers so all of the slicer buttons are unwieldy.
Is there a way to select the slicer value (ie which Manager) from either a filter or a cell value?
Thanks in advance
1 Reply
- Detlef_LewinSilver Contributor
Hello
Here are two solutions from Jon Acampora.
How to Filter or Sort a Slicer with Another Slicer + Video
How to Add a Search Box to a Slicer to Quickly Filter Pivot Tables and Charts + Video