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
|