Using combined (conjoined) filters

[#1]

In want to exclude sales manager 'james'  "in" region 'south' on my sales dashboard.

So when James pops up in region north that is no problem

When clicking south in the listbox of the regions, and excluding clicking salesmanager james in the salesmanager listbox I only retrieve the numbers regarding region south.

What can I do to employ a correct interpretation?

[lironbaram]

you need to do it like this

select james

then select South

then do select excluded on the region field

if you wnat it in a formula you can use set analysis

sum({<manager={james}, Region=-{South}>}sales)+ sum({<manager=-{james}>}sales)

[#3]

Hi Liron, This does not work.

It excludes the region while selecting only james. So now I solely have the name james rather than all sales managers.

I didn't try the set formula because is essential for my end-users to be capable to exclude in such way using easy navigation.