Highlighting specific values/table results

[#1]

Hi there,

I would like to ask for some help with a security audit report I have created for one of our applications. The idea is to review the users in security groups and flag wherevere there is a breach in segregation of duties (where the same user is both an approver and a user for a specified business unit)

So far I have managed to display this by using a pivot table, note in the attached report, User10 is both Approver and User.

The problem is all other users which have only one role are displayed in there as well so its difficult to spot the breaches.

Is there a way of either limiting the table to display the users that have both values or highlighting the cell with the user10 (preffered option!).

Appretiate your help!

Regards

Marek

[whiteline]

You can expand 'plus' left to your expression or dimension and type an expression for background color.

[#3]

Hi,

Thanks for this, I tried adding

=Address and If([Address] = 'Approvers' ,RGB(255, 255, 0))

to the 'Address' dimension (which is the User field...) just to try whether it will work for a single condition but it does not return any values now. definitely doing something wrong!

Could you please provide an example expression?

Thank you

Marek

[whiteline]

lesm,

Why are you comparing [Address] with 'Approvers' ? [Address] has only values UserNN.

Use

=If([Roles] = 'Approvers' ,RGB(255, 255, 0))

Also, I think you didn't understand me. You should just Click on '+' on dimension.

Then choose 'Background Color' and there type a color expression.

[#5]

hi again,

yes got confused with the 'plus' bit! now its clear.

The issue with the highlighting bit is that I only want to highlight the specific instance that User10 has (whereby he is both in approvers and users) thats why i originally tried to add the expression to Address (quite stupidly in hind sight!)

While adding the color expression to a single instance (where Role=Approvers) works fine, I cannot workout how to specify to highlight the User who is in both!

when I try to use:

= if([Roles] = 'Approvers' and [Roles]= 'Users' ,RGB(255, 255, 0))

it highlights everything as I think it looks at users and approvers in separation instead of instances where they are both.

hope that explains my plight! Any ideas how to solve this?

Thanks again for the help

[Anonymous · Accepted solution]

Is this what you want to do? I had to do a binary load but you can add the Users and Approvers flag to your script.

[#7]

Thank! thats exactly what I was looking for!

Regards

Marek