Cross tabs - Demographics by Zip Code

3830
6
07-07-2016 08:01 AM
GaryScray
New Contributor

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 2016Total Population 2021Total Population 2016Total Population 2021
90210####
90211####
90212####
0 Kudos
6 Replies
DanPatterson_Retired
MVP Emeritus

Like in a pivot table? Pivot Table—Help | ArcGIS for Desktop

or I have some python code

0 Kudos
GaryScray
New Contributor

Yes, a pivot table would be great.  I only have access to Business Analyst Online and ArcGIS Online however.

0 Kudos
DanPatterson_Retired
MVP Emeritus

well, there is always excel's pivot table, I can't find BA online help

0 Kudos
GaryScray
New Contributor

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!

0 Kudos
DanPatterson_Retired
MVP Emeritus

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

0 Kudos
RakeshSinha
Occasional Contributor

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

0 Kudos