Counting Observations in Pivot Tables

[epicentre]

Hi everyone,

I hope someone can help me with this. I have a client list I want to summarize by observations of a date.

Example base data

CompanyName DateVisit Salesrep Clientcontact
Company1 01-Nov Sales1 Client1
Company1 01-Nov Sales2 Client1
Company1 01-Nov Sales3 Client1
Company2 01-Nov Sales4 Client4
Company1 02-Nov Sales2 Client1

I now want to summarize how many "visits" I had per company, so I create a pivot table:

CompanyName Clientcontact Visits
Company1 Client1 2
Company2 Client4 1

Right now, I get 4 as result for Company1 since there are 4 different rows with data. But taking "Date" as base, there are only 2 "observations". This is what I'm after.

How can I get a pivot table to summarize like this?

Many thanks!!

Mike.

[steven1001]

Here is a kludge that achieves it. It requires adding helper columns.
regards