Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

RLS Filter User But Show Other Users Anonymously

Hi, I am able to use the Role Management feature to filter out data per username. This shows only the data for the specified user and hides everything else. However, I still want the user to be able ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

I'm wondering if you could add a Rank column in your user table first, then create a new summarized table which contains only the rank and other information you want users to compare with in this scenario(mark sure there is no any relationship with this summarize table). :smileyhappy:

 

Regards

Anonymous's avatar
Anonymous
Not applicable
8 years ago

So, basically you are saying to substitute the username's with a number? Including the user viewing their report. I would prefer if the user viewing the report could see their own name, but everyone else as "Anonymous". I am also not trying to show a "rank", just a way for the user viewing to compare where they are with the rest of the group.