idea Maps for Office - Pivot Table Multiple Rows in ArcGIS for Office Ideas

Maps for Office - Pivot Table Multiple Rows

ToddHenry1 — Tue, 16 Aug 2016 15:10:37 GMT

Please add support for pivot tables that contain multiple row labels. There is often information within my pivot table that are attributes of my point data that I want to show in the pop-up as well as maintain the integrity of my pivot table. However, currently that is documented as unsupport and will make it difficult to gain adoption of the tool within our organization if they are limited to just using a single unique identifier as their row label.

Re: Maps for Office - Pivot Table Multiple Rows

ScottPrindle — Wed, 14 Sep 2016 05:09:19 GMT

Hello Todd,

Thank you for submitting this idea. Unfortunately, this is currently a known limitation.

Could you provide an example screenshot of this pivot table with multiple levels, including an idea of how you'd like this information presented in a pop-up? If we can better understand where you're coming from and what you're attempting to do, it may be possible to approach the issue from another direction.

Thanks,

Scott

Re: Maps for Office - Pivot Table Multiple Rows

ToddHenry1 — Wed, 14 Sep 2016 15:05:49 GMT

Scott,

The reason for the request is that users like to look at both the pivot table and the map. When reviewing the pivot table it would be convenient for them to see the name associated with the location. Here is a screenshot of the pivot table without our data that shows the setup. If you put the pivot table in tabublar view, the data for each point is on 1 row.

It did figure out how to get the store name from my ArcGIS Online content to show up in the pop-up by including it as a field when I created the custom location type.

<http://www.dickssportinggoods.com/home/index.jsp>

Todd Henry

Sr Technical Manager, Real Estate Market Research

345 Court Street l Coraopolis, PA 15108

todd.henry@dcsg.com<mailto:todd.henry@dcsg.com> l o: 724.273.4026 l m: 412.522.3269

<http://www.facebook.com/dickssportinggoods>[cid:image003.jpg@01CEB48E.2B0533C0]<https://twitter.com/DICKS>

Re: Maps for Office - Pivot Table Multiple Rows

ScottPrindle — Mon, 19 Sep 2016 22:55:44 GMT

Hey Todd,

It looks like your screenshot did not come through in your response. Could you modify your comment or post another reply to share this information?

I will change this idea's status back to "Reviewed" so we can continue to gather votes and comments on your suggestion. I think you have a valid request, even though we are currently running into a known limitation.

Thanks,

Scott

Re: Maps for Office - Pivot Table Multiple Rows

ToddHenry1 — Tue, 20 Sep 2016 11:13:10 GMT

Scott,

Here is the screenshot again. Please let me know if you can’t see it or I need to put it in a zip file.

Re: Maps for Office - Pivot Table Multiple Rows

ScottPrindle — Tue, 20 Sep 2016 20:35:46 GMT

Hey Todd,

I'm still not seeing the image. You can email it to me at sprindle@esri.com and I will see if I can determine why it's not appearing in these comments. Have you been using the comment formatting tools and the "Insert Image" one in particular?

Thanks,

Scott