Calculated Field in Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have the following data:

Team Name Closed#
1 John 2
1 Bill 5
2 Jane 1
2 Joe 6
3 Mary 1
3 Don 2

I have a Sum of Closed and a Count of Name in the data section of my table.
I need to divide Sum of Closed by Count of Name for each Team but can't
figure out how to do that. When I try a calculated field, I only have Name
as a selection, not Count of Name.

Thanks in advance.
 
xgirl said:
Hi, I have the following data:

Team Name Closed#
1 John 2
1 Bill 5
2 Jane 1
2 Joe 6
3 Mary 1
3 Don 2

I have a Sum of Closed and a Count of Name in the data section of my table.
I need to divide Sum of Closed by Count of Name for each Team but can't
figure out how to do that. When I try a calculated field, I only have Name
as a selection, not Count of Name.

Thanks in advance.
Click to expand...
 
Thank you Viji. When I tried that I get an incorrect value. I used this
formula in the calculated field:

=SUM(Closed)/COUNTA(Name)

For team 1 I would expect to get 3.5 but I get 7. Where have I gone wrong?

Thank you,
xgirl
 
Back
Top