Not sure how to do that within a pivot table but you could probably do it
outside of the pivot on the raw data.

If you want to go that route give me the details of the layout (and be as
specific as you can).

Biff
Microsoft Excel MVP

"Keith" wrote in message
...
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?