How to show a count of Unique IDs in a Pivot Table

  • Thread starter Thread starter Dave K
  • Start date Start date
D

Dave K

Is there a way to use Pivot tables in a way that shows a count of
Unique IDs (over time).

The problem I am having in using the Pivot table to show trended data,
is that the "Count" option produces a count of each record that has
any information, when oftentimes I simply need a count of unique IDs.

So the below Column would have a count of 3 Names, when I prefer for
it to produce a count of 1 Name. Any recommendations would be
appreciated.....

Name
 
Back
Top