Forum Discussion
How to filter a report by current user?
Hello everyone.
I was asked to create a report that is individual, that is, the user accessing it will only be able to see its results.
However, the user will also need to see the production of the team they are part of.
The user should not see other people's numbers, only theirs compared to the rest of the team.
I am importing the data via live connection from another report that is already used by leadership, but I am not finding a way to do this properly.
Can you help me?
1 Reply
- lbendlin
Super User
This won't be possible via live connection. You need to create a second copy of your fact table that removes the user details, and then use that anonymized version as the baseline to compare to. At a minimum you need a direct query connection with local data model to do that, and maybe even an import mode connection.
