|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 13th, 2009, 06:45 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Mystery field in pivot table
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 ! 
|
|
#2
May 13th, 2009, 10:43 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mystery field in pivot table
Ray C wrote:
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 ! Did you know you can double click a data cell in the PT and a new worksheet will open showing the detail rows from the source table?
|
|
#3
May 14th, 2009, 08:28 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mystery field in pivot table
Hi Ray
Is column R hidden on the Source sheet? Right click on the PTPT WizardBack and what is the source range? -- Regards Roger Govier "Ray C" wrote in message ... 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 !
|
|
#4
May 14th, 2009, 03:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mystery field in pivot table
Yes, I already did that and the mystery field is not even there, yet the
records were filtered. "smartin" wrote: Ray C wrote: 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 ! Did you know you can double click a data cell in the PT and a new worksheet will open showing the detail rows from the source table?
|
|
#5
May 14th, 2009, 03:40 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mystery field in pivot table
There are no hidden columns in the source sheet, and the source range is
A1:Q62410. From A to Q implies 17 fields. Yet, there are 18 fields in the PT's available fields list. Another thing I tried was this: I opened the source sheet and added filters for each column on the first line. When I clicked on each drop-down list on each column, none of them have the options that appear when I click the mystery field's drop-down on the PT. So I really don't know where this field is getting its data from (in the PT)? This mystery field is one of two column fields in the PT (if that helps). "Roger Govier" wrote: Hi Ray Is column R hidden on the Source sheet? Right click on the PTPT WizardBack and what is the source range? -- Regards Roger Govier "Ray C" wrote in message ... 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 !
|
|
#6
May 14th, 2009, 04:04 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Mystery field in pivot table
Sounds very strange, Ray.
If you would like to mail me direct with a copy of the workbook, I will happily take a look. To mail direct, send to roger at technology4u dot co dot uk Change the at and dots to make valid email address -- Regards Roger Govier "Ray C" wrote in message ... There are no hidden columns in the source sheet, and the source range is A1:Q62410. From A to Q implies 17 fields. Yet, there are 18 fields in the PT's available fields list. Another thing I tried was this: I opened the source sheet and added filters for each column on the first line. When I clicked on each drop-down list on each column, none of them have the options that appear when I click the mystery field's drop-down on the PT. So I really don't know where this field is getting its data from (in the PT)? This mystery field is one of two column fields in the PT (if that helps). "Roger Govier" wrote: Hi Ray Is column R hidden on the Source sheet? Right click on the PTPT WizardBack and what is the source range? -- Regards Roger Govier "Ray C" wrote in message ... 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 | |
| Display Modes | |
|
|
Linear Mode
