topic Re: Cross tabs - Demographics by Zip Code in Business Questions

Cross tabs - Demographics by Zip Code

GaryScray — Thu, 07 Jul 2016 15:01:25 GMT

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	#	#	#	#

Re: Cross tabs - Demographics by Zip Code

DanPatterson_Retired — Thu, 07 Jul 2016 15:16:48 GMT

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

or I have some python code

Re: Cross tabs - Demographics by Zip Code

GaryScray — Thu, 07 Jul 2016 15:43:13 GMT

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

Re: Cross tabs - Demographics by Zip Code

DanPatterson_Retired — Thu, 07 Jul 2016 16:20:35 GMT

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

Re: Cross tabs - Demographics by Zip Code

GaryScray — Thu, 07 Jul 2016 16:27:11 GMT

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!

Re: Cross tabs - Demographics by Zip Code

DanPatterson_Retired — Thu, 07 Jul 2016 16:30:04 GMT

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

Re: Cross tabs - Demographics by Zip Code

RakeshSinha — Thu, 24 Nov 2016 07:56:31 GMT

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