| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to create a calculated field from another calculated field?
In a pivot table report I would like to add a calculated field that is like
the following: = count( columnA ) / count ( columnB) But when I create a calculated field like the above, all I get is a value of 1 in every row of the pivot table. I realize after some experiments, its really performing = count( sum ( columnA ) ) / count( sum ( columnB ) ) So , how do I get what I want? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Finding unique items in data field for pivot tables | Excel Discussion (Misc queries) | |||
| Calculated field in pivot table | Excel Discussion (Misc queries) | |||
| Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
