P
PJS
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
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