Simple example file attached.
I have hire date data formatted as a date with month/day/year.
In the drop-down I can filter according to year/month/day.
In the pivot I cannot.
Any reason why?
My data set is very large and to click all those I want to filter in the pivot is not possible.
Bookmarks