In a data sheet I have rows of which in one particular date column  there is a date filled in or no date.(blank).  The date is a proof of delivery date.  

I would like to build a pivot table only filled with the rows that in the particular column has not a date ( = blank) . so all rows should be reflecting those who have no proof of delivery date in it ( = not delivered) 

How can i obtain this.

If I selct the column and try to put a filter it does not let me to select blank or emty or...   only a date range or a year or month... 

can someone let me know how to build this pivot? 

thanks for your help, 

Fons