Calculated Field in Pivot Table
"xgirl" wrote:
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.
|