Restricting Specific fields without reducing rest of the data
Hi All,
I have a below requirement which is unlike Section Access and below is the Data
Region
Sports Name
Price USD
Sport Value USD
ASIA
Basketball
455000
76000000
ASIA
Carrom
650000
250000000
Central Europe
FootBall
1631250
400000000
Central Europe
Swimming
115915.6862
27562800
PACIFIC
Soccer
303661.41
110400000
PACIFIC
Hide and Seek
358800
69000000
UK
High Jump
123690
92340000
UK
Cycling
145200
40691640
US
Running
458999
485765
US
Boxing
129756
48202714
Now requirement is- if user belongs to ASIA and Central Europe then he will be able to see data as below
Only Sport Name and Region Column should be restricted for him while rest of the data should appear as is
Region
Sports Name
Price USD
Sport Value USD
ASIA
Basketball
455000
76000000
ASIA
Carrom
650000
250000000
Central Europe
FootBall
1631250
400000000
Central Europe
Swimming
115915.6862
27562800
303661.41
110400000
358800
69000000
123690
92340000
145200
40691640
458999
485765
129756
48202714
Below are the users regions of access
ACCESS
NTNAME
USER
Name
USERTYPE
REGION
ADMIN
1
1
Kathrine
INTERNAL
*
ADMIN
2
2
Joe
INTERNAL
*
USER
3
3
AB
INTERNAL
*
USER
4
4
Deep
INTERNAL
ASIA
USER
5
5
Shristi
INTERNAL
ASIA
USER
4
4
Deep
INTERNAL
Central Europe
I like to implement the same in back end as I have reduced data for this query but my dashboard has data in GBs with multiple sheets. I am even open for a solution which I can implement on UI as well.
Will really appreciate your help and thanks in advance for the same
