Hi,
Please help me to get the solution for the below scenario.
For Eg:
Table1:
Country, Group
UK,ABC
US,XYZ
HK,PQR
US,ABC
HK,ABC
India, XYZ
Table2:
Country, Sales,Item
UK,200,A
US,300,B
India,400,C
HK,500,D
Result:
Apply section Access for a user who belong to group ABC but his country is US, can able to see the data for UK,US,HKand India at high level but he can able to drill down for US.
I tried to create a excel which is containing multiple rows based on Group and Country but i want all those information in one row and apply section access on that
For eg. Expected Result:
User , Group, Country1, Country2,country3,country4 and so on
A,ABC,UK,US,HK
What i have:
User,group,country
A ABC Uk
A ABC US .. and so on
Thanks,