Pivot table wonkiness

I had a major problem with one of my pivot tables today and was not able to find a solution online. The issue was that not all of the data was showing up on my table. Every time I would refresh I would get different data, but not all of it. I am not sure what caused this but I found a solution. Pull the fields out of row labels, hit refresh, then drop them back in. I don't know why this worked, but it did.