How can I count the number of unique dates in a Pivot Table?
 

I need help with counting unique dates in a Pivot Table.

The data range is like this:
Date Name Amount
1/1/06 Mark 15.00
1/1/06 Mark 10.00
1/5/06 Mark 35.00
1/7/06 Mark 12.00
1/7/06 Mark 22.00


What I need the Pivot Table to show is this:

Name Amount #of Visits

Mark 94.00 3

I keep getting 5 for the number of unique visits instead of 3
(1/1/06,1/5/06,1/7/06).

Is there any way to do this?

Thanks,

Mark

How can I count the number of unique dates in a Pivot Table?
 

Debra Dalgleish show one technique:
http://contextures.com/xlPivot07.html#Unique

mpsfeldt wrote:

I need help with counting unique dates in a Pivot Table.

The data range is like this:
Date Name Amount
1/1/06 Mark 15.00
1/1/06 Mark 10.00
1/5/06 Mark 35.00
1/7/06 Mark 12.00
1/7/06 Mark 22.00

What I need the Pivot Table to show is this:

Name Amount #of Visits

Mark 94.00 3

I keep getting 5 for the number of unique visits instead of 3
(1/1/06,1/5/06,1/7/06).

Is there any way to do this?

Thanks,

Mark

--

Dave Peterson