Pivot Table counting blank as values

[Miskondukt]

Hey there, this must be the dumbest question I've asked on here. I have a table where there aren't any names or values, text or anything in the column's cells but when I create a pivot table to count # names in the columns all the counts are the same. See attached example file.

Thank you kindly

[PeteABC123]

Uncheck Sales Rep, or remove from your row field.
pete

[peterrc]

Under Values, change Count of Agent to Sum of Agent.

peterrc