Pivot table - supect "counts" column

[Rad]

Hi,
I’m wondering why i’m seeing random values for colum “counts” in pivot table. As per my understanding each row should have “1” but maybe my understanding is wrong.

I’ll appreciate any feedback:

[Max]

This would mean that you have more rows that also have the same column values.

I would continue to add columns to see what’s duplicated.

[Rad]

Thanks, will test it.