+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Help Needed

  1. #1
    Registered User
    Join Date
    06-28-2022
    Location
    New Orleans
    MS-Off Ver
    2016
    Posts
    1

    Pivot Table Help Needed

    I am sure there is a simple explanation to this, but I am having trouble figuring it out. Below is a simple data set for a pivot table. It has an airport code, a primary flight delay code, and a secondary delay code.
    Pivot Data Set.png

    Here is a simple pivot table I made using this data set. I have customized the fields to display the information to my liking.
    Pivot Table.png

    Here is the issue I am having. In the pivot table, the Secondary Code total is mirroring the Primary Code fields. If you look at DCA, they have two separate Primary Codes of A11 and T02. My pivot table also shows a two secondary delay codes as well, even though the data set I drew this pivot table from had no secondary codes in it.

    I would love to be able to get this sorted out, as my goal is to combine 31 data sets as the one above into one monthly pivot table. Thanks for any assistance!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Pivot Table Help Needed

    It's not clear what you expect to see. Your Data contains a blank Secondary Code

    Why don't you mock up the layout of the results you expect. In addition please upload the workbook
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Needed a unique drop down list from a duplicated table without pivot table
    By Noman050 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-04-2022, 12:58 PM
  2. Help with Pivot Table needed
    By Ohio Tournaments in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2014, 07:03 AM
  3. Macro Help Needed - Link Pivot Table Filter to Regular Table AutoFilter
    By ycx1129 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2011, 12:54 PM
  4. Pivot Table Help Needed.
    By JonnyNYC90 in forum Excel General
    Replies: 4
    Last Post: 11-01-2011, 12:10 PM
  5. Pivot table help needed
    By blinden1983 in forum Excel General
    Replies: 2
    Last Post: 06-21-2011, 02:16 PM
  6. *Pivot Table Help Needed*
    By iEnjoi in forum Excel General
    Replies: 6
    Last Post: 10-21-2010, 01:58 PM
  7. help needed with pivot table
    By funkymonkUK in forum Excel General
    Replies: 2
    Last Post: 06-12-2006, 04:17 PM

Tags for this Thread

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