I have a set of data that I can't share. Fake data are attached. The problem is this:
I have a filter that does not have the "All" value available. Therefore it has to be set to something.
However, that same value is being used for server-level User Filters.
So the filter is set to the value of Ames when I publish the workbook. When someone logs on who does not have access to the value Ames, they see no data and they have to go to the dropdown to select one of the values that they do have access to.
This is just one more step for a group that is not super comfortable with tech in the first place. Is there any way I can get the filter to always set itself to something that the current user has access to?
Would setting the filter to allow the "All" input work for this? Or is there a reason you don't want them to select "All"?