A couple of weeks ago I was asked how to filter a pivot table based on a range of dates when the field containing the dates isn’t part of the pivot table.
There’s more than one way to do this and in this video I’m going to show you 4 different methods and discuss the benefits and drawbacks of each one. The 4 methods are:
- Use the Filter area in the Pivot Table Fields Panel
- Add a Timeline to the Pivot Table
- Add a Slicer to the Pivot Table
- Allow the user to type the first and last dates into two cells and use a formula-based filter: =IF(AND(B7>=$N$6,B7<=$N$7),”Y”,”N”)