Count a list based on a value

Need help Database
1

I have a database with one value that has a limited number of options.

Subdivisions:
Name(text) , Manager(User), Identifier(text)

I want to make a table to count how many subdivisions one person has.
Ex:
Tyrone - 1
Mindy - 5
Sarah - 3

How would I accomplish this?

2

Hi there, @therealglitchxy… if I understand your post correctly, try using a repeating group with a data source that looks like this.

group
group876×563 43 KB

Then, add two text elements to the repeating group, with the first element displaying the Current cell's Grouping's manager's name and the second element displaying the Current cell's Grouping's count.

Hope this helps.

Best…
Mike