Hide a Column based on User Access

[#1]

Can we hide a column based on user Access/Windows AD?

For e.g: I have the below column. My section access will be on Cost Center field. Also, I would like to hide the column Salary where Salary Show = 1. So, only 'bbc' would see the salary details.

employee Name	Salary show	Salary	Cost Center
aaa	1	877	401
bbc	0	455	501
ccc	1	544	601

Any suggestions?

Thanks in advance.

[alexandros17]

In expression use conditional check box and test osuser() with the user you want to exclude

[srchilukoori]

If you are using the section access, add the field name in the Hide condition on the presentation tab. This will automatically hide a chart when the user's Show Salary value = 0.

[maxgro]

search for omit in the attachment

[#5 · Accepted solution]

If the Secction Access table is linked to the table you describe by the employee Name, when you access the application there should be just one [Salary show] value. For this to work the Secction Access table must have the [employee Name] field in order to link tables.

If that is so, then if salary is treated as a dimension, check the option to hide it on conditional when [Salary show]=0. If you are treating it as an expression, then show on conditional [Salary show] = 1 (on the expressions tab of the properties menú of the object).

[#6]

Thanks everyone. It worked. I used show condition in expression while using section access on Cost Center.