Symbology by Size of Aggregated Field

svector

Hi all, I learn GIS as I go and I'm usually able to figure things out eventually, but sometimes I'm missing the appropriate search terms. If I have a table like the one below and I want to symbolize budget range by dot size, where many records will fall into the same FIPS codes, how would I aggregate the budget total for each FIPS code. In the past, I did the work in the file prior to adding to ArcGIS but I'm wondering if there's a feature/tool that will easily do this or whether writing an expression would suffice (if so, extra thanks if anyone can get me started on that expression!) TIA!

 

objectID	Shape	st_abr	FIPS	budget
1	point	TX	48001	100
2	point	DC	11001	500
3	point	TX	48001	800
4	point	AZ	04001	250
5	point	AL	04001	300
6	point	TX	48001	980
7	point	CT	09001	850
8	point	AZ	04001	300
9	point	DC	11001	970
10	point	NH	33001	540

AmyHut

Are you wanting the sum of 'budget' from all points with same FIPS code? I'm sure there are other methods, but you can use the Dissolve tool, using FIPS as your Dissolve Field and the budget field as a Statistics Field and SUM selected as Statistic Type. This tool will create a new feature class with a field called SUM_budget which can then be used for symbology. There are a number of different statistic types to choose from (e.g. range) if another is a better fit for your question.

Staying tuned for any help with an expression too...