Forum Discussion
Bypass RLS for a measure
Hi everyone, :))
I would like to give you an example of what I would like to achieve as it is hard to explain :).
Due to RLS Student "A" could only see his average scores, whilst I would like him to see the average for both A and B. in this sense, how can I let a measure bypass/skip RLS
Student NameGradeTerm
| A | 23 | 1 |
| A | 32 | 2 |
| A | 21 | 3 |
| A | 22 | 3 |
| B | 20 | 3 |
| B | 19 | 3 |
| B | 19 | 2 |
| B | 21 | 2 |
| B | 29 | 2 |
your help is much appreciated,
Amr
1 Reply
Hi Anonymous
What if you create a new table (Table2) with a single column and row which just stores the average for both A & B?
You can then set your RLS as per usual on your first table but then you do not need to set any RLS on Table2 and you can display that average however you want.
