Hi Charon Wang ,
Yes tableau can handle this , you need to create different worksheets as per your requirement and then add all those in a dashboard . Now about the clicking thing ,you can do that with "Actions" ( Dashboard -> Actions) you will get this dashboard option when you will be on dashboard .
You can get what you are looking for even if you will hover over your data .
Thanks for your reply.
I know that Action is able to connect between charts and worksheets. But I have no idea of how to use Action to control different worksheets by selecting different cells in a table. Could you please elaborate more on that or is there any tutorial talking about that?
As shown below, I have done the first part which uses the first list to control the content in the 2nd list. However, I am not sure about the 2nd part: use the 1st list to choose the chart type (bar chart or map), and use the 2nd list to control the values shown in the chart.