I have a list of places our reps visit along with who they visited and
various other things. I then bring this data into a pivot table.

I want to see a total of how many times they visited each Town, but I only
want the town counted once of any date, so if they visit London on the
02/07/07 and went to 4 placed there will be 4 lines in the data but the pivot
table only counts 1. But if they went to london on the 02/07/07 and then
again on the 05/07/07 then the pivot table will count 2.

Anybody got any ideas how this can be none?