I have a pivot table referencing a tab in excel that imports and refreshes my data from another system.

I am using the count distinct option in my pivot table to avoid counting duplicates. The total seems to be off by 1 count. Not sure if the pivot table is counting blank rows or the header row as a unique record?

I do not know how to adjust the pivot table operation to fix this?

The import data is automated and will refresh every time I open the excel file so I want to avoid adjusting the raw data unless the adjustment I make can be preserved every time the excel document/data is refreshed.