I have a Pivot Table which was created by another user (no longer contactable), as well as the source data, located in a single workbook. The source data is an Excel Table. The Pivot Table contains two extra fields that are not in the source Table. The two fields appear to be predefined groupings of a field that exists in the Table (i.e. when source = 1 or 2 or 3 or 4, new field # 1 = A, etc...). The Pivot Table then is able to show summarized values by the grouping.
When I go to the Analyze tab --> Fields, Items, & Sets --> Calculated Field or Calculated Item, I don't see any specific calculations for these fields. I was thinking that it could have had something to do with the Excel Table being the source, but I can't find anything in the table to suggest an additional grouping.
Any help on figuring out where these additional fields in the Pivot Table are coming from, and how they are being set, would be much appreciated. Thank you in advance.
When I go to the Analyze tab --> Fields, Items, & Sets --> Calculated Field or Calculated Item, I don't see any specific calculations for these fields. I was thinking that it could have had something to do with the Excel Table being the source, but I can't find anything in the table to suggest an additional grouping.
Any help on figuring out where these additional fields in the Pivot Table are coming from, and how they are being set, would be much appreciated. Thank you in advance.
