Pivot Table Unique ref

B

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.
 
R

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.
 
Top