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.



1 Reply


As far as I know, that is not possible.