RLS Rules

[SuRe]

Hi all,

I want to set up a RLS for our sales persons. In my main report I show sales revenue and budget figures as well as customers and similiar. With the RLS I want to filter by this sales person. He should see either his own data or total company data, but not the data of each separate other sales person.

my filter would be: (AN are the credentials of the sales person)

[ASM] = "AN"

But how to include the total numbers? I tried

[ASM] = "AN" || [ASM]="*"

But this does not work.

Any ideas?