Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2007 Pivot table Calculated field misbehaving
Using EW2007.
Trying to insert a calculated field into a pivot table. It's not displaying any results besides zero's on the calculated field. I think what may be contributing to the lack of results, is that one of the source fields used in the custom calculation is already used twice in the pivot table. (once in the row labels area on the left(displayed as its field value), and another time in the values and is displayed as "Count".) Any ideas of how I might get this calculated field to. . . calculate? TIA. . . Pierre |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2007 Pivot table Calculated field misbehaving
Does the field contain text? If so, its sum is zero, so that's what's
used in the calculated field. Pierre wrote: Using EW2007. Trying to insert a calculated field into a pivot table. It's not displaying any results besides zero's on the calculated field. I think what may be contributing to the lack of results, is that one of the source fields used in the custom calculation is already used twice in the pivot table. (once in the row labels area on the left(displayed as its field value), and another time in the values and is displayed as "Count".) Any ideas of how I might get this calculated field to. . . calculate? TIA. . . Pierre -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 Calculated Field | Excel Worksheet Functions | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Calculated field in Pivot Table | Excel Discussion (Misc queries) |