Hello,

I am trying to count unique values in a pivot table instead of "Counting how
often multiple values occur by using a PivotTable report" section.

Let say my pivot table shows

Team 1 John 5
Jane 10

Team 2 Mark 20
Paul 4

I would like to count Team 1 = 2 people with a total of 15 and avg 7.5
and Team 2 = 2 people with a total of 24 and avg 12

Since my data is measure over time, for every record with a John, it would
count 4 instead of 1 with the sample data below.

John 2/1/08 1
John 2/2/08 3
John 2/3/08 1
John 2/4/08 0

Any help will be great,

Thanks in advance!

PJS

Needs two helper columns:
http://www.freefilehosting.net/download/3bj0l