But you've asked a question about this map previously, and a packaged workbook was involved then--so why not just use that packaged workbook?
Here is the workbook from that previous thread, modified to address this issue. Basically, I just set a worksheet action (using this same sheet for both the source and targets) on the "Market" field used for coloring the market/region. You could also simply click the drop down options menu from your "Market/Region" legend, and select "Highlight Selected Items" (or simply click on the little highlighter icon on the legend). Both of these do the same thing (create an action on the Market field)
Hope this helps. By the way, to create sample datasets quickly, here's what I do:
-Copy and paste a subset of records into Excel; making sure the data is representative of my actual/production data
-Randomize/remove any sensitive/uneeded fields.
-Pull that data into Tableau, extract it, and post on the forum. Takes only a few minutes after some practice.
In your screenshot, you have a three sheets on a dashboard selected as the source (what you will click on), and then sheet 32 as your target (what will be affected by the click)--without seeing your workbook, I can't know if that is correct.
If the goal is to click on any area in any of those 3 maps, and have that selection update all three maps, then you would want the dashboard with the three sheets as both the Source and Target sheets. Does that make sense? Since my example only had one sheet in use, it was much simpler.
My example used a highlight filter as well, rather than an action filter--but the concepts are the same. If you want to filter a sheet by the area selected, you need to set up an appropriate filter action that links the Source/Target sheets on the "Area" dimension. Experiment with it, and I'm sure you'll figure it out--if the target sheet(s) are on a dashboard, then you'll need to select the dashboard under "Target Sheets" and then select the individual sheets you want filtered below that (it would look the same as your "Source Sheets" area in the screenshot above, which lists a Dashboard then the sheets on the dashboard below that).
Basically The current Dashboard I'm modifying is a map view with 3 layers, But I just want to click any part of the the dashboard and have it transfer me to this other worksheet and show me the values of the selected area instead of the State I'm clicking.
I just crosschecked the information I'm seeing and it worked!! I just had a table view of the data by areas and that's how I confirmed it.
Sincerely thanks a lot! This may have been a rookie question.. But I really appreciate your help!
The more I use tableau the more I learn how to manipulate data to show what I want.