Calculated Field in Pivot Table

[xgirl]

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.

 

[viji]

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.

 

[viji]

Hi,
You can use counta to count the name and you can use autosum to sum closed#.

viji

 

[xgirl]

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