pivot table treating some values differently

[bradams]

I have a pivot table where the Row is Zip Code and the Value is a count of zip code. In other words, it is counting how many times each zip code appears in my data set. There are 35 zip code values. Everything works perfectly for 33 of the 35 but for some reason the pivot table is treating 2 of the zip codes differently. Let's call the two outlier zip codes A and B. At the end of the 33 zip codes, it is inserting a subtotal. Then below the subtotal are the rows for A and B.

I have a related pivot table where the zip codes are grouped by county. A and B are left out of the pivot table entirely even though I've double-checked to make sure they are associated with a county in the data set. Other zip codes for the same county work fine.

I cannot figure out what is causing the pivot table to treat A and B unlike the other 33 zip codes. I have rebuilt the pivot table from scratch. I used format painter to make sure the rows in my data set where A and B appear are formatted exactly the same as the other rows. There are no filters being applied. I'm not sure what else to check and would love to hear some suggestions. Thanks!

 

[bradams]

Never mind. That wasn't a subtotal. It was a count of rows that had IF formulas returning "". It just happened to be roughly 50% of the total number of rows so I assumed it was a subtotal. Dumb mistake.