Home

Pivot Table filters

%3CLINGO-SUB%20id%3D%22lingo-sub-500520%22%20slang%3D%22en-US%22%3EPivot%20Table%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-500520%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20problem%20with%20the%20filtering%20of%20pivot%20tables.%20I%20have%20a%20data%20base%20with%20a%20list%20of%20instructors%20down%20the%20first%20column%20and%20a%20list%20of%20qualifications%20down%20the%20first%20row.%20I%20have%20a%20slicer%20that%20will%20only%20show%20me%20the%20instructors%20that%20meet%20the%20qualifications%20I%20have%20filtered.%20The%20problem%20is%20the%20qualification%20list%20on%20that%20first%20row%26nbsp%3Bis%20so%20long%20it%20does%20not%20fit%20on%20the%20page.%20How%20can%20I%20get%20the%20pivot%20table%20to%20do%20a%20drop%20down%20list%20filtered%20by%20row%20the%20same%20way%20it%20does%20it%20by%20column.%20Or%20how%20do%20I%20group%20the%20row%20portions%20into%20a%20filter%3F%20I%20have%20tried%20to%20transpose%20the%20data%26nbsp%3Bbut%20then%26nbsp%3Bthe%26nbsp%3Binstructor%20slicer%20does%20not%20work.%20Any%20thoughts%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-500520%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-506626%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-506626%22%20slang%3D%22en-US%22%3ECould%20you%20post%20a%20screenshot%20to%20help%20us%20understand%20what%20you're%20situation%20is.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-507929%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-507929%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-507938%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-507938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329912%22%20target%3D%22_blank%22%3E%40hnjracing13%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-509883%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-509883%22%20slang%3D%22en-US%22%3EThe%20problem%20is%20with%20your%20source%20data%2C%20you%20can't%20do%20what%20you%20want%20to%20do%20in%20a%20Pivot%20Table%20unless%20you%20%22unpivot%22%20the%20data%20first.%20You%20can%20do%20this%20with%20Power%20Query%20if%20you%20have%20Excel%202013%20or%20Excel%202016.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20have%20Excel%202013%20you%20can%20download%20Power%20Query%2C%20if%20you%20have%20Excel%202016%20or%20Office365%20then%20it's%20already%20built%20in.%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20you%20have%20one%20of%20these%20versions%3F%3C%2FLINGO-BODY%3E
hnjracing13
New Contributor

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?

4 Replies
Could you post a screenshot to help us understand what you're situation is. Thanks
The problem is with your source data, you can't do what you want to do in a Pivot Table unless you "unpivot" the data first. You can do this with Power Query if you have Excel 2013 or Excel 2016.

If you have Excel 2013 you can download Power Query, if you have Excel 2016 or Office365 then it's already built in.

Do you have one of these versions?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies