Apply a drop down filter on a each column of a pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2595078%22%20slang%3D%22en-US%22%3EApply%20a%20drop%20down%20filter%20on%20a%20each%20column%20of%20a%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595078%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20a%20Microsoft%20Office%20365%20and%20using%20Excel%202016%20MSO.%20I%20am%20trying%20to%20add%20a%20drop%20down%20filter%20for%20each%20column%20(in%20the%20example%20below%20a%20filter%20for%20each%20of%20the%20work%20days)%20in%20the%20Pivot%20table%20such%20that%20I%20am%20able%20to%20sort%20and%20filter%20for%20the%20%23%20of%20hours%20in%20a%20single%20Week%20Day%20alone.%20Would%20really%20appreciate%20support%20on%20this.%20I%20have%20seen%20it%20before%20except%20I%20don't%20know%20how%20to%20apply%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2595078%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2595085%22%20slang%3D%22en-US%22%3ERe%3A%20Apply%20a%20drop%20down%20filter%20on%20a%20each%20column%20of%20a%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1115665%22%20target%3D%22_blank%22%3E%40smokdad1994%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20far%20as%20I%20know%2C%20that%20is%20not%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi all,

 

I am working on a Microsoft Office 365 and using Excel 2016 MSO. I am trying to add a drop down filter for each column (in the example below a filter for each of the work days) in the Pivot table such that I am able to sort and filter for the # of hours in a single Week Day alone. Would really appreciate support on this. I have seen it before except I don't know how to apply it.

 

Thanks!

1 Reply

@smokdad1994 

As far as I know, that is not possible.