Filtering the order number/text

[Uygar-Hamburg]

Hi,

How can I set a filter that shows all orders that contain "*XYZ0*" in the order number?

Can I enter this as set analysis in the order number filter?

Thank you for your help!

[AshutoshBhumkar]

Hello,

Yes you can add a set like below to get only records which contain "*XYZ0*".

E.g 

Sum({<[order number] = {"*XYZ0*"}>}Sales) //Just an example

Thanks,

Ashutosh

[Uygar-Hamburg]

Thank you Ashutosh,

I will put the formula on the measures.

If I want to filter it without set analysis, I think I need to set a filter in the data load editor?

[AshutoshBhumkar]

Yes, you can use condition like

Load

A,B,[order number]

From........

where wildmatch([order number],'*XYZ0*');

[Uygar-Hamburg]

Hi Ashutosh,

I have tried this formula in the data load editor

where wildmatch([order number],'*XYZ0*');

but it does not work

Do I need to change something?