I have a scenario where I am having a straight table with 2 dimensions and an expression.
Please find the screenshot below:
Dimension B is having 2 values for every value in dimension A.
And here I want to handle confidentiality, that is for particular selections the data cannot be shown, it will be NA.
So for my particular selection of Dimension A, if my confidentiality is failing for 1 value in dimension B, it should show NA for both the values of Dimension B. Because if I add a total to that column, from total anyone can get the value for NA.
Any idea how can I handle confidentiality at the row level.
Let me know if some more information or clarification required.
The normal and common way to handle confidential data is to implement Section Access within the application which just removed the confidential data on a user-level by opening the application. But you will need some kind of a multi-staging process if you want to keep totals for fields which are data-reduced for users. For this requirement might be this posting helpful: Mask or de-identify data for certain users using Section Access.
Another approach which could be quite expensive would be to try o implement it by chart-expressions which query the user and if your show-conditions are true and which chart-level is beeing used - I mean something like: