Just throwing this out there - I am sure a lot of people love the slow response, but what I really need is a 60-second video showing your screen clicking through the steps of getting this done! Maybe you could be the guy to have both the long video and a link to a short video that solves the same problem.
when you create the action, there are 3 options "select", "hover", and "menu", if you choose "menu" then it won't pop up automatically, you have to use the right-click menu to go there
Really useful and got me started. Do you know if it's possible to do the opposite (sort of). If I select 'central' in sheet 1, then can I *not show* (exclude) 'central' and only show the others (exclude central). I'm trying to do something similar and take the selected "profit' of "central" and use that to calculate the %age difference in sheet 2 for other areas. Thanks
OK Jason - sorry for the delay. I'm trying to follow along with what you are trying to do. One quick way to do this is to put a "Region" filter on Sheet 1. Click the drop down for this new "Region" filter and hover your mouse over "Apply to Worksheets". In this sub-menu click "Selected Worksheets". Check off your Sheet 2 worksheet which should be your profit worksheet. Now in Sheet 1 you can Right Mouse Click the central region bar and click "Exclude". This will show all other regions except for Central in both Sheet 1 and Sheet 2. Is that what you were trying to do?
Apologies for late reply. Holiday! Yes thank you. This is part of the solution. The extra was use of a FIXED level of detail based on a parameter. Thanks for helping out.
useless I need create a filter which would be displayed in Dash, that's it, but he doesn't show that. why to name your video like this if you don't deliver
