| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Calculated Field
I have a pivot table in which the data area includes a 'count' of a text field. I am trying to create a calculated field which will divide the sum of a numeric field by this count field but it doesn't seem to be working. The formula looks as follows: ='sum Field'/COUNT(data field). The result I am getting is simply the sum of the numeric field. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove a Calculated Field from the Pivot Table field list | Excel Discussion (Misc queries) | |||
| Pivot table, IF function, calculated item versus calculated field | Excel Discussion (Misc queries) | |||
| Creating a Calculated Field in a Pivot Table for same field | Excel Discussion (Misc queries) | |||
| 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) | |||
Linear Mode
