benchmark data in combination with Row Level Sequrity

[Anonymous]

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 all the data is filterd for this role and a benchmark is not possible.

Example.

Manager X see only his department, but can also see the total and average of all managers

Wiht kind regards, Norbertus

[AiolosZhao]

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