Group and get percentage.

Question

Need help summarizing data in ArcGIS pro.  If this was querying a SQL database directly I would have no problem.

I want the Total Acreage of each Zoning Classification based on Parcel Data.  I will then want the percentage of acreage per zone of the total acreage.

Robert LeClair · Answer

Another option to consider is this Technical Support article that I believe would work for you.

DerekBernard · Answer

Yeah, the Summarize Attributes tool allowed me to get the sums by attribute value and then I just used Excel to produce some Percentages.  Thanks.

DavidPike · Answer

Possibly https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/summary-statistics.htm

using the 'Case' constraint to group by attribute.

or https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/pivot-table.htm

post ArcGIS Pro 2.6 you can create a database view using SQL also https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-view.htm