Excluded from result selections filter

[#1]

Hi,

I need to build a selection filter that contains values  I want to exclude from result.

For Example  I have this filter:

When I selected Accounting or Casino etc.,I need that excluded this Values from my result.( for example report etc.)

How can I do it?

Thanks a lot

[sunny_talwar]

You can do something like this in your expressions:

{<Category = e(Category)>}

[sfatoux72]

To don't disturb users, you could perhaps create a island table with the field ExcludedCategory

T_ExcludedCategory :

Load Distinct Category as ExcludedCategory

Resident TableWhere CategoryFieldIs;

The user will clearly select the category that he want exclude in the field ExcludedCategory

And use in your expression Sunny solution write like that :

{<Category = e(ExcludedCategory)>}