I'm trying to understand the issue here but may not fully have it. What would happen if you had all functions selected by default (not necessarily using the All option as you said that should be hidden) and set the filter to relevant values? That way User 1 would only see A, B & C while User 2 should see D & E. Perhaps this may fall over as User 1 publishes and can't see D & E so therefore even selecting All doesn't select D & E behind the scenes.
Hi Andrew, thanks for your time and efforts . The obstacle here is that the client does not want the "ALL" option and also the client wants a single value drop-down . Let me know if any feasible solution is possible for this .
Hi Ben, to get a clearer picture on the doubt.Can you take datafrom Sample Store.Take 2 filters. Region and state . Then put region in context filter and for state, take the State filter as only values in context. So in sheet 1 , when we take east region as my filter, we only get the States that are a part of east region . Also I have taken the east region as single value drop-down . Also we are showing data for New York at present for segment wise quantity.
So the main query that I have is when we change the Region from east to Say central, the sheet goes blank as the data captured was for New York which is not part of the central region. So is there a way to dynamically update the state filter . also the state filter should take anyone State by default .