Aggregate totals in a Zip Code data set by State

[DavidEvans2]

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.

[RiyasDeen · Accepted 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.

[DavidEvans2]

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!