[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

PivotTable

Hi,

I have a pivottable and in two fields excel put a 2 after the fieldname.
0
sonmic
Asked:
sonmic
1 Solution
 
helpfinderCommented:
probably better would be to attach the mentioned file or create a sample with the same problem if original file is confidential
0
 
LazyFolkCommented:
is the fieldname already used somewhere in the workbook ?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

column headers (field names) must be unique in a pivot table source. If you have two data columns with the same name, Excel will MAKE them unique by adding a number at the end.

cheers, teylyn
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now