Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a pivot table in a worksheet that is based on the data from another
worksheet in the same workbook. The data worsheet has 17 columns (from A to Q) with 62410 lines worth of data. When I view the pivot table's list of available fields, I have 18 fields, not 17. So I naturally thought that someone added a calculated field. But when I looked, there is no extra calculated field. This extra field only has about 5 values and I don't know where these 5 values are coming from. Aside from the data source or calculated fields, I'm wondering if there is another way of adding a new field in a pivot table. Can anyone help me? I'm stumped. This workbook was given to me. I did Ctrl-F to find the 5 values in the data worksheet and they are NOT there in any column. Help ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum a pivot table field as a calulated field | Excel Discussion (Misc queries) | |||
sum field is zero when using Pivot table | Excel Discussion (Misc queries) | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Pivot Table Field | Excel Worksheet Functions |