Hi Team,
I’m trying to configure user access in so that certain metric values are hidden for specific users, while the table structure (rows and columns) remains visible.
For example, as shown in the screenshot, I want users to see the list of Countries, along with Cost and Gross Margin numbers — but the Revenue values should be completely hidden for them. Essentially, the user should still be able to see the row and column headers, just not the restricted metric data.
I tried setting up Data Access Rights based on Roles, but it either hides the entire row or still shows the Revenue numbers.
Has anyone implemented this type of partial metric-level masking? What is the best way to achieve this?
Thanks in advance!
