I have a table with 10000 rows and 10 columns, i have added 10 slicers for 10 columns.
I want to have a search box for one of the slicer, i found from youtube videos that if i add a pivot table for that column and keep it above slicer i can do the search
I done the same it is working, but the problem is i want to keep the data, slicers and pivot all in same place, this is causing Error. "A Pivot table report cannot overlap a table", i want to know is there anyway to ignore this error or
any other way to add a search box for the slicer?