+ Reply to Thread
Results 1 to 7 of 7

Duplicate field in Pivot Table field list

  1. #1
    Registered User
    Join Date
    12-07-2023
    Location
    Vancouver
    MS-Off Ver
    2021
    Posts
    46

    Duplicate field in Pivot Table field list

    Hello,

    There is a duplicate field in a pivot table with a 2 at its end.

    Have ungrouped everything, but cannot get rid of it.

    Anyone have a solution ...?

    Thanks in advance.
    - Mik

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Duplicate field in Pivot Table field list

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    12-07-2023
    Location
    Vancouver
    MS-Off Ver
    2021
    Posts
    46

    Re: Duplicate field in Pivot Table field list

    Appreciate where you're coming from, but it's a huge file that cannot be distributed.

    Thank you.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,200

    Re: Duplicate field in Pivot Table field list

    Provide a copy that has been cut down and desensitised, but shows the problem.

    NOBODY has asked for you to provide a huge file full of sensitive data.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    12-07-2023
    Location
    Vancouver
    MS-Off Ver
    2021
    Posts
    46

    Re: Duplicate field in Pivot Table field list

    Understand, have done it many times.
    In this particular case it can't be cut down.
    Always appreciate everyone's assistance in this forum, if there are general guidelines on this that would be great.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,200

    Re: Duplicate field in Pivot Table field list

    Without even a screenshot of the issue, there won't be a lot anyone can do.

  7. #7
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,966

    Re: Duplicate field in Pivot Table field list

    Sounds like you may have two columns in the source data with the same header.
    Everyone who confuses correlation and causation ends up dead.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-15-2019, 08:54 PM
  2. New Field / Column added not getting displayed in Pivot Field List
    By excel_googler in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-02-2019, 05:42 AM
  3. Pivot Table: Calculated Field based on Running Total Field
    By EvolvingMonkey in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-07-2016, 06:27 AM
  4. Replies: 0
    Last Post: 08-15-2016, 02:07 PM
  5. [SOLVED] A pivot table field calculated using other field values as fields?
    By chrisf78 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-07-2015, 03:08 AM
  6. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  7. Replies: 3
    Last Post: 03-03-2012, 12:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1