To all the Problem solvers out there:
I have a data set that provides a total number of contributions broken down by zip code for a certain month e.g. total contributions in Zip Code 10001 in August might be $400, while 10002 is $0 etc…
I would like to determine the sum of these contributions by State. My zip code layer contains a field that identifies the State that the zip code is located in, so I can easily use the Select by Attributes builder and the Statistics function within the Attribute table to create a selection and then determine the total for each state, however, I’m sure there must be a smarter way then having to perform the same set of operations 50 times over (Using Model Builder perhaps?).
I’d appreciate any advice on how to achieve this, there may be a specific tool in the ArcToolBox that do exactly what I need which I am overlooking.
Solved! Go to Solution.
Hi David,
What you need is summary statistics ArcGIS Desktop .
In Table: your dataset
Out table: Specify a table to be created
statistics_fields: Your contribution field, with statistics type sum
Case Field: your state code column.
You summary will come out grouped by state code in the output table.
Hi David,
What you need is summary statistics ArcGIS Desktop .
In Table: your dataset
Out table: Specify a table to be created
statistics_fields: Your contribution field, with statistics type sum
Case Field: your state code column.
You summary will come out grouped by state code in the output table.
Thank you Riyas! Your solution does exactly what I needed. The output is a table, but I can easily join that back to another shapefile to visualize the output.You are a star!