Forum Discussion
Row Level Security
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.
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.
1 Reply
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.