Hi @v-chenwuz-msft ,
Thanks for your reply. However, the slution as your mentioned, which can't covert this situation as we have the below scenario.
|soldier||AMC;IT||GZ;HZ;CD||The guy can see the data of GZ under the AMC & HZ, CD under the IT(company AMC and IT both contains GZ BU...) split by ";" and change to row.|
Based on it, we dont want to let the guy to see the HZ data under AMC. Because the above access setting will show 6 records....