Mystery field in pivot table

  • Thread starter Thread starter Ray C
  • Start date Start date
R

Ray C

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 !
 
Hi Ray

Is column R hidden on the Source sheet?
Right click on the PT>PT Wizard>Back and what is the source range?
 
Hi Ray

Is column R hidden on the Source sheet?
Right click on the PT>PT Wizard>Back and what is the source range?
 
Yes, I already did that and the mystery field is not even there, yet the
records were filtered.
 
Yes, I already did that and the mystery field is not even there, yet the
records were filtered.
 
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).
 
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).
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem inserting calculated pivot fields into Pivot Table (2007) 1
Single Filter to change all Pivot Tables in a Workbook 8
Pivot table formulas 1
Pivot Table Calculated field error 1
Pivot Table - 3
pivot table data 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table 1

Back
Top