All data with Row level security

[Anonymous]

Hello,

I have an issue with application containing Row level security , Security running properly . Now requirement is when user logged in application then user can see their respective sale and compare with ALL India sales . Security is implemented on Field Dealer Name Kindly help me to achieve this. Thanks in Advance

[Gysbert_Wassenaar]

Remove the security that prevents the user from seeing all Indias sales.

Or create a summary table with all India sales at whatever level of detail the user is allowed to see.