Pivot field filters

[Keith Walsh]

I have a pivot table which lists items in its drop down filter list that are not actual items in that database field. The field name is "City" and it lists the cities, yet it also lists dates and other data that are nowhere in the database. I am puzzled.