Count of Unique Field

[nihou]

Hello, I am trying to count the number of reports using a key field.  I want to count how many unique reports.  I have tried, running total and then the summarize (group by and count), but it does not get me the results that I would like.

[phottovy · Accepted solution]

@nihou 

You should be able to use the summarize tool for this with a "Group by" on record type and "Count Distinct" on Fed/Lease No:

[nihou]

That worked, thank you!