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

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.