Pivot tables and duplicate data

Goal: When I create a pivot table I select to know which location and what has not been signed. The idea is to have the pivot table show me how many unsigned contracts a location has.   The issue: ...