Applying RLS Not getting what I wanted?

[Anmolgan]

Hi

I am trying to achive a clustered column bar chart, which will contain a aggregated sales from all the comapnies and total sales of a particular company, to achive this I have made 4 tables one for each company and one containg total sales from all the companies, I have also made the RLS roles for all the companies (1 role for each), what I am finding is the roles works fine for each of the company, but when I try to achive the role using the particular users what I am finding is the roles are not working, I have attached the screenshots of my relationship digram, my data, and the graph which I am trying to achive please through some light on this.graph when RLS is applied for each user excluding the company RLS

RLS When Roles are selected for users and roles for users are selected

my relationship digram

[v-chuncz-msft]

@Anmolgan,

The requirement is not very clear. Share a complete example if convenient.

[Anmolgan]

What I want is the green bar to show total sales from all the companies except the company of which I am viewing the data.

How to achive that??