filter in Diagram

[#1]

Hello

I want to filter 5 customer exclude from our Customer (20.000) and use this for a Diagramm. How can i do this.

Thanks

[#2]

Hi,

Add a field to your script for tagging the target customers. Something like:

IF(CustomerID='123' or CustomerID='234' or CustomerID='456' or CustomerID='4598' or CustomerID='286' , 'TheOne') AS CustomerTag,

Use this field to filter your chart or table in the frontend.

Regards, Sander

[#3]

Hi,

I will 5 Customer exclued from our Customer Tabel and select the Net Value in one Diagramm and in other Diagramm i will display the Net Value from all Customer.

is the formel right? can i the 5 Customer exclude in bookmark, if yes how?

IF(CustomerID is not '123' or CustomerID is not'234' or CustomerID is not'456' or CustomerID is not'4598' or CustomerID is not='286' , 'TheOne') AS CustomerTag,

Thanks

Regards

Shideh

[#4]

Be careful, when your logic tests for "is not" or "not equal" you need to connect the tests with AND's not OR's. In your above code, CustomerID 234 is not '123' and therefore will pass. Actually, everything will pass when you use OR's.

John