Total Customers by City


#1

Hello, I am hoping someone can help me. I have a simple Table that lists my customers, City, Postal Code. What I would like to do is create another table that can list all the Cities and Total the number of customers in each city.

Thank you all for any help.


#2

Hi Paul, the easiest way to do this is to make an ordinary grid view with columns for Name, City, Postcode.

Then use the Groups function and group them by city.

This should give you a summary field for each city. You may need to change the summary function to Count.

You can also collapse all groups to have that information at a glance without scrolling.

Here’s an example base you can duplicate and use as a starting point.


#3

You also can convert your City field to a Linked record field, so you’ll have another Cities table, and the Cities connected to the Customers. Then you can add a Count field to that table that will give you the number of customers by City. This way you could have extra information about the Cities, but if you don’t need this or other advanced queries you can create a gid view as said by @Matt_Sayward


#4

Thank you for your help. Such a quick response.


#5

Thank You Elias, I think I will try the other solution for now. Maybe when I get more comfortable I will try your solution.