+ Reply to Thread
Results 1 to 2 of 2

Pivot Table ignoring/grouping duplicate values it believes are the same

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    Granada Hills, CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Pivot Table ignoring/grouping duplicate values it believes are the same

    I have a list of values on Shippers and because there are more than one line with the same item and same shipment value it is combining/grouping the two lines as one. I need to find a way to display these lines separately without altering the source data by adding a line item.
    shipper part qty total
    570894 7005397-002 CSP/BGA OVERMOLDED 202 1017
    7005397-002 CSP/BGA OVERMOLDED 303 1017
    7005397-002 CSP/BGA OVERMOLDED 310 1017

    There are two lines with a qty of 202 and excels pivot only includes the line once but without the total line there would be no way to know info might be missing. It should display 202, 202, 303, 310. How can I achieve this?

  2. #2
    Registered User
    Join Date
    06-09-2011
    Location
    Granada Hills, CA, USA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Pivot Table ignoring/grouping duplicate values it believes are the same

    Created a line item key field and included it in the pivot before the part # to get pivot to recognize as unique item. Would have liked a way to do it without adding another item to the pivot but it will do.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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