Trying to reverse engineer a pivot table and cannot figure out where this column reference is

[jtpryan]

This is some work from an employee that left. There is one sheet with a large table in it. Columns A-->Q 1400 rows. On of the Columns is labeled "Environment". Now in the pivot the Rows quadrant has three things in it:

Month
Environment
Environment2

Environment2 seems to be a calculated field based on the data in Environment. But I cannot find this anywhere. I have highlighted the entire worksheet where the table is and selected unhide and nothing is hidden. Environment2 is a field in the same list of PivotTable Fields above the quadrant.

How was this done? I cannot figure it out. Where could this field be? If i create a pivot based on that same table that field does not appear.

Thanks for any help, I'm about all out of hair.

Jim

 

[mrshl9898]

Click on the Pivot then go to Analyze>Fields, Items & Sets>Calculated Field.

There's a dropdown in the name box showing if there are fileds there

 

[pkdeimos]

Jim,

Have you checked the list of calculated fields under "Formulas" in Pivot table options?

 

[jtpryan]

Thank you both. But no joy. Environment2 does not show up anywhere.

 

[mrshl9898]

The name Environment2 suggests it is the Environment field, but i'd only expect Environment2,3 etc to appear in the values (as a count or average etc.), not the rows.

 

[jtpryan]

Yes, I know what you mean, but it isn't. The data in that field, wherever it is, seems to be calculated from the environment field. Both of which are text fields.

 

[mrshl9898]

Are you able to upload a copy?