Forum Discussion
Solved
Summarize Data for Map Visualization
Our sales territories, are basically a hierarchy of Regions, Subregions, Locations. So the table has all of the Lats and Longs for each location. I'm wanting to sum up the sales by each Subregion...
Hi,
You do not need to create second table. Just select the aggregate function as Average for Lat and Long
Hi,
You do not need to create second table. Just select the aggregate function as Average for Lat and Long
This shows all the locations. I'm trying to display only the subregions. When I put Subregion in the Location and change the Lat and Long to Average, it still shows all the locations.
Nevermind. It's because I had Location in the tool tip. Wow that was much easier than I thought. Thank you!
You are welcome.
