Need Help to Sort Data in Airtable Spreadsheet

Hello Guys.
Here is my Airtable Spreadsheet Demo.
image

Here you see that abc purchase 3 items.
I want to show in label that “Mr. abc Purchased 3 Items”
I mean i want to find that how many entries available on that particular name?

I Don’t know how to do it. Please help me to solve this issue.

Best Regards

Pls ref this method , and slightly modify the blocks as per your needs

An example with CollinTree Listview:
Screenshot_111

Try something like this

2 Likes