crhaines94

New Member
Joined
Mar 4, 2019
Messages
1
Hello All,

I am trying to create a map that shows Unique territories. These territories are typically multiple states, but they could be a whole country. These territory are then assigned an industry and a sales rep. That sales rep is then in charge of all sales for that territory.

So for example,

If I have a slicer that has #12 selected, the map would show states: GA, AL, TN, NC, & SC

but if # 11 was selected, it would show states: MO, NE, KS, & IA.

Any ideas on how I can accomplish this?

Eventually I will assign data to where if you hover over the territory, it would show sales data.

Thanks!

Chris
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,108,984
Messages
5,526,058
Members
409,682
Latest member
HisHailo

This Week's Hot Topics

Top