Joe Oppelt already reacted on a similar thread with this. The other thread can be found here: Why I have to double click on dashboard to use the action or filter
His reaction was the following:
"I've seen this question raised several times. It's annoying.
In one of the threads Ville Tyrväinen posted the attached workbook. It's a hack that does a count increment on a calc field that causes the value to be reset, thereby unmarking the mark, or something like that. I wish I could find the thread where it was discussed. There were some caveats and other discussion about this trick.
I saved the workbook for some day when I would have to deal with the problem. So far my users are OK with double clicking, but I know the day will come when someone won't tolerate it. Then I'll dissect this workbook, understand what Ville did in there, and use the principles he employed."
Filter_Trick_VT.twbx 979.6 KB
Thanks Matthias, I will go through attached twbx and try to see if I can understand/implement what has been done.
Appreciate your quick response on this!
You can achieve it using Worksheet actions. Create the worksheet action for the sheet from where you want to navigate to another sheet. Refer the attached workbook. It has Dashboard 1 which contains the sheet with Navigation (Region sheet). When you create the Worksheet action ( not Dashboard Action!) , specify that it should be activated on single click and use the action type as filter.
Navigation.twbx 283.2 KB