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!
Bookmarks