Apr 29 2019 10:22 AM
I have a problem with the filtering of pivot tables. I have a data base with a list of instructors down the first column and a list of qualifications down the first row. I have a slicer that will only show me the instructors that meet the qualifications I have filtered. The problem is the qualification list on that first row is so long it does not fit on the page. How can I get the pivot table to do a drop down list filtered by row the same way it does it by column. Or how do I group the row portions into a filter? I have tried to transpose the data but then the instructor slicer does not work. Any thoughts?
Apr 30 2019 04:59 PM
May 01 2019 03:53 PM