How to get rid of (blank)

[BORUCH]

Hi all

I have a pivot table and one of the columns is salesman.
For some reason when I drag it to the rows section of the pivot table, it lists all salesman and a (blank) at the end
The problem is I have no blank records I can figure out where it is getting the “(blank)” from

 

[63falcondude]

I believe when you select entire rows (i.e A:F), it picks up a few rows after your data. I found it easiest to simply filter out the (Blank) from the pivot table.

 

[BORUCH]

I believe when you select entire rows (i.e A:F), it picks up a few rows after your data. I found it easiest to simply filter out the (Blank) from the pivot table.

I only have this issue when i create a relationship to another table
but the problem is that both tables have the same s/m with no blanks in there
any way to fix this issue at its roots