Pivot Table Unique ref

[Bod]

Do I need to put a field which contains unique identifiers for each record
into the Data Items (bottom right) bit of the pivot table?
I thought I did, but when I used a field that doesn't have unique records,
the count was still the same.

 

[Roger Govier]

Hi

The count will be relative to the Row Fields (and/or Column Fields).
i.e it will be a count of the data field that matches the Row/Column fields.