I'm not sure this exactly can be done. However, it is possible to change how an action is run so that by just hover over the point of data will make it run.
I couldn't get it.Could you elucidate.
Stop advertising your company board here if you have no help to offer.
There are a couple options that I can think of:
- Set the filter how you want it, then save the workbook. The next time you (or anybody) opens the workbook, it will come up filtered how you saved it. No user action is required.
- Like Tracy suggested, you can set up a filter action on hover, so that if you simple move the mouse over a mark in a master view, it will trigger a filter in the detailed view. It doesn't require a click, but it does require the user to move the mouse.