Row Level Security

[Shreeram04]

Hi All,

I need to achieve dynamic row-level security for the area, country, and territory columns. I can do it for both area and country but I am unable to find the solution for territory.

1. When I enter Apac level means it shows value APC area values only.

2. when my country is china means its shows china's country values only.

3. And if I enter as south territory for china means its shows value for south territory for china only.

Sample data:

Area	Country	Territory	Profit
APAC	Taiwan	North Territory	328376.4
APAC	Turkey	South Territory	933903.8
China	China	East Territory	4509794
SAM	Argentina	West Territory	59960.32
SAM	Mexico	North Territory	1187679
EMMA	Saudi Arabia	South Territory	202941.7
APAC	Taiwan	West Territory	287316.9
APAC	Turkey	North Territory	477944
China	China	South Territory	162892
SAM	Argentina	East Territory	2280701
SAM	Mexico	West Territory	363198
EMMA	Saudi Arabia	North Territory	26185.28
APAC	Thailand	South Territory	2093016
APAC	Turkey	West Territory	15549.03
China	China	North Territory	2334947

when I did for territory means its shows dates like south territory for all areas and countries but my requirement is its show value for particular country-based territory. Please help to identify the solution, thanks in advance.

[negi007 · Accepted solution]

@Shreeram04 i would suggest you to create a calc column in your table based on country and territory and then apply RLS on that column.

Your new column could be like 

country_territoy = tab[Country] & "|" & Tab[territory]

in that way it filter correctly. In your current situation, you have noth, west, south and east territory in many countires.