Pivot Filtering by Dates

b19upj

New member
Joined
Mar 31, 2015
Messages
8
Reaction score
0
Points
0
Hi,

I have a worksheet with a number of columns. two of these are dates and are formatted the same (as far as im aware).
I want to make pivot tables with other columns fields following on from these dates, so I created 1 pivot for Completion Due date and another for Completion Date, but when I try to filter by date, i can only do it by 'date' on the Completion Due Date field and 'value' on the Completion Date field.
I want them both to be filterable by date.
Do you know why i am unable to filter one by date when i can the other?

TIA
 
Thanks for letting me know for next time. My apologies.
 
Back
Top