i have a table per user with a field called level,
the request is as follows:
don't show level for specific employees for Users,
for example,
i have this KeyTable:
UserID
Level
1000
A
1001
B
1002
B
1003
C
1004
A
1005
B
1006
C
For user 1 show all level values,
for user 2 the level field should be reduced like that:
UserID
Level
1000
1001
B
1002
B
1003
C
1004
A
1005
1006
C
for user 3 the level field should be reduced like that:
UserID
Level
1000
A
1001
1002
B
1003
1004
A
1005
B
1006
C
is there a way to do that using section access or any other way?
i cant use a calculated dimension because of security issues( the user can duplicate the table and change the calculated dimension).
please see the attachments of the qvf and excel files,
in the excel there is a Groups table
i thought maybe to create a field for every group of permissions (I have about 100 groups of permissions) so i can create a 100 different fields for the field "Level", but i don't want to loop 100 time over the KeyTable (the table contains 20 Million rows),
