I am new to the community, working on a report pulling numbers by County. I have one field "county" that has the name of a county. Trying to pull this into a report summary and show a list of each county name that is in the database with the corresponding count for each (i.e. Riverside appears 10 times and San Mateo appears 3) I need to show the counts for each county that shows in a list.
The counties change weekly in our database with new records and such, I don't want to create a count for each county with it always changing.
Can I break out each unique county name and create a count? Any assistance is greatly appreciated.
Hi,
You could try adding a Query Calculation to your list with an expression of 1. In the properties of the column, set both the Detail Aggregation and Summary Aggregation properties to be Total.
Does this give you what you need?
Cheers!
MF.
That works perfectly, thanks so much!