I'm trying to create cross tabs with select esri demographics as columns and zip codes as rows.
Is there a way to do this in Business Analyst Online or ArcGIS Online?
Total Population 2016 | Total Population 2021 | Total Population 2016 | Total Population 2021 | |
90210 | # | # | # | # |
90211 | # | # | # | # |
90212 | # | # | # | # |
Like in a pivot table? Pivot Table—Help | ArcGIS for Desktop
or I have some python code
Yes, a pivot table would be great. I only have access to Business Analyst Online and ArcGIS Online however.
well, there is always excel's pivot table, I can't find BA online help
I can work with that. Is there a way to pull the data down by ZIP so it can be pivoted in Excel?
Also, I appreciate your help Dan!
you just stepped outside my realm, I don't use BA or AGOL as a source of data. You would have to consult their respective documentation to see if it is even possible. This may be an issue if the data is read-only and/or just for use within the confines of those packages. Good luck
Hi Gary,
Take a look at the following documentation. This would help you pull data based on Zip code/s.
Select Geography—Business Analyst Web App | ArcGIS
I hope this helps!
Cheers!
Rakesh