Pivot Table counting values

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Filter Formula 1
Pivot Table Question - HELP! 2
Pivot Table counting a range 1
Pivot Table Dates 1
Countif or sumif for cumulative sums,pivot table & chart 2
Calculated Field in Pivot Table 3
Insert formula in a pivot table 5
Sorting Count Values in Pivot Table (Excel 2007) 1

Top