It's because you have blanks in your data set....you can't just remove them in the pivot, you have be more accurate in the data you select, just the 177 rows, not down to 65000....