Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field in Pivot Table
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field in Pivot Table
Hi,
You can use counta to count the name and you can use autosum to sum closed#. viji "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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculated Field in Pivot Table
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 "viji" wrote: Hi, You can use counta to count the name and you can use autosum to sum closed#. viji "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Pivot Table - Calculated Field | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table | Excel Worksheet Functions | |||
Calculated Field in Pivot Table | Excel Worksheet Functions |