# Aggregating multiple layers while preserving values using ArcMap?

I am using ArcMap 10.5 to display the distribution of Revenues by Region, for each product I have defined.

Each product has a layer of its own consisting of a collection of polygons, and each polygon contains attribute fields for revenues over a period of 10 years (e.g. Revenues2005, Revenues2006, etc)

I am trying to create a kind of cumulative heatmap.

For example, let's take two polygons with the following fields, each in a separate layer, but that overlap exactly:

Layer1

Rev1 | Rev2 | Rev3

5000 | 6000 | 7000

And

Layer2

Rev1 | Rev2 | Rev3

1000 | 2000 | 2500

Would it be possible to combine the above layers, such that when the polygons overlap, I would obtain a new layer with a polygon of the following attributes:

Layer3

Rev1 | Rev2 | Rev3

6000 | 8000 | 9500

So far the (tedious) solution I found is to combine the fields pairwise and use a python script to add the revenues for each year one by one.

• If you're only interested in symbology, then you could use transparency, so overlapping polygons would appear darker, representing larger numbers.
– Paul
Commented Feb 15, 2017 at 1:30
• Hi Paul, I would actually like to add the fields from the layers and obtain new values per polygon. Are you aware of a good way to do this? I already tried using unions on tables on which I joined my xlsx tables, however the fields get renamed to Rev1_1, Rev2_1, etc instead of being given a way of combining them Commented Feb 15, 2017 at 5:39
• gis.stackexchange.com/questions/133866/… has a few solutions.
– Paul
Commented Feb 15, 2017 at 16:17