Excaping RLS in specific report

[Tal_Aruety]

Hi there,
I have a requriemt which i am not sure how to obtain.
I have a model with Row level security
so lets say i have a granular fact table table, which in one report shoul show only data allowed by row level security
i.e. each user can see only his transactions in the report.
On the other hand, i want a report, in which all users can see all the data, but not in a granular way.
For example
every one can see the average sales of each user, in a certain period
but no one can see the actual rows making that average.
I am seeking a way where i can share both reports, in one app, without duplicating my dataset, as it has all the data needed for both reports.
Thanks a lot
Tal

[Greg_Deckler · Accepted solution]

So, in general the way I have worked around this issue is by creating a summarization table within the model. This table is disconnected from any tables that have RLS applied. By doing this, users can see summarized data but not the underlying data that comprises those aggregations.

[Tal_Aruety]

Thanks Greg,

Ill go with that solution, if you find out other ways to workthis without speically duplicating data, i would love that.