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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Mapping 1
Creating unique keys 2
Pivot Table Unique Cnts 1
Pivot Table Data Aggregation 0
Count Number of Unique Cells That Don't Have Certain Characters 0
How to have two tables on same line? 1

Top