I was hoping to get some help with a problem I am working on. I have two shapefiles, a point file that includes a column for group, and a polygon shapefile. I need to figure out A) how many points are in each polygon and B) how many of each group are in each polygon (for example area A has three points in group 1, four points in group 2, and zero points in group 3)
I was able to solve problem A with no problems, I simply did a join which added the count column to the new polygon shapefile. I am having problems trying to figure out how I am suppose to solve problem B. Does anyone have any suggestion as to how I can go about doing this?
The end goal is a spreadsheet with the area name, the total count of points in that area, and the count of points for each group in that area.
I am using ArcGIS 10.2 for Desktop and I have the basic license.