Hi friends of Tableau,
I have a question about specific user filter:
In my example there are 3 agents who work for the same company (Mr Doe, Mr Smith and Mrs Jones).
Each agent can only see his own results/sales. In this case I used instead of Username()=[Agent]
the condition [Agent]='doe' in order to simulate Mr Doe, who is loged in as Tableau user 'doe'.
Now he only sees his records.
But I also need a way that he will be able to see the aggregate/ total values like in worksheet 'Total'.
There should be a filter where he can choose between his name and an option 'all'.
But he is not allowed to see any filtered records of his co-workers.
Is there a way to realize that?
Thanks for any tips.