Showing different table column name based on viewer roles

[JC25]

I am trying to show different column name for different viewer roles. I have a column in a table named ABC. I want to make it so that when I pick User 1 and User 2, the column header will be ABC, but when I change the viewer role to other roles e.g. User 3 the column header will change to XYZ. Is there a way to do this?

[_AAndrade]

Hi @JC25,

Could you please tell me if my post solved your issue? If so, could you mark my message as the answer to this problem?
I'd be very grateful. Thank you very much

[_AAndrade · Accepted solution]

Hi @JC25,

I think it's possible to solve this problem using field parameters.
1 - Create a field parameter with the two columns that you want.
2 - Add a new column on your usernames/roles table that you are using to apply the RLS and classified each username with the number of the order parameter (created on the first step) according your needed

3 - Link the Parameter table with the usernames/roles table

4 - Use the parameters filed on the matrix instead of the column.

I did a quick example, please take a look:
1 - Field Parameter

2 - Add new column

3 - Relationship between the two tables

4 - Final Output

I hope this can help you to solve your issue.