Report - Display the Count of the Grouped item - Not the Count of the items

[Newell]

I have a report that is grouped by the "Assigned To" field.   I want to display this report as a Count of the Groups, but I can only get it to display as a count of the total items.    Grouped the Count is 300 but there is 1300 items.   

[Mahnoor_Azhar · Accepted solution]

Hi @Newell,

In the report builder, under the "Data" tab, ensure that you have the "Group by" field set to "Assigned To."

In the "Aggregation" field, select "COUNT DISTINCT."

Regards

Mahnoor Azhar

[Newell]

Thanks, a cat cannot see what is directly in front of their nose.  I must have some of their DNA.