Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

benchmark data in combination with Row Level Sequrity

Hi.   We want a report that uses Row Level Sequrity so people see there own data. But they also want benchmark data what the other roles do. This benchmark is a total and average. When we use RLS...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

I think you can create another table to calculate the total and average.

 

And you need to make sure that the new table is not linked to your old data model.

 

So the RLS won't effect the new table you created.

 

Then for every one, they will see the total and average.

 

Please try.

Thanks.

Aiolos Zhao