When all of the members to go to a different worksheet/dashboard are on the same worksheet Menu Actions need to be used. However, by creating several worksheets and placing them on a dashboard so that they look like one sheet will allow you to add filter actions with just a 'Select' (click of the mouse). I have attached a sample workbook showing this.
Hope this helps!
table of contents1.twbx.zip 1.2 MB
Thanks Tracy for the help. There is still a problem here. There are around 20 items in my table of contents sheet. Do I have to create 20 sheets to resolve this issue?
I have the same question what Deepak asked, If I have to put 20 items in the Table of Contents then do I need to create 20 sheets for each items and put them in one dashboard?
Is there is any other way to do this?
Any help would be appreciated.
Thanks in advance!
I have the same question about having to have a single sheet for each TOC entry. This seems nuts to have to create a sheet for each and every dashboard or sheet that you want to have a TOC entry. I have 15 dashboards or sheets in my default workbook, I could/will have more for each individual clients.