Dimension Filter

meh

I need to filter certain dimension codes in order to generate reports but because of the Overflow of text i am not able to generate required report.All the filtering codes didnt work for me .
For eg i have codes 2-2-01-1-000-0(Around 50 with -000-) and likewise other codes starting from 001 to 075 in place of 000(2-2-01-1-001-0) . Is there any filtering logic to generate report excluding other digits and just generating reports of 000 and also reports from 001 to 075 excluding 000.

Hope to hear back ..

matttrax

Load your filters into multiple text variables. Then do a SETFILTER(Field, '%1', Text1 + Text2 + Text3)

tch55

Maybe you can use 'wildcards' in your filter.
It seems as though you could use a filter like this:

Define MyFilter as a textvariable.
MyFilter := '2-2-01-1-???-*';
Table.SETFILTER(Dimension,'%1',Myfilter);

Remember '?' subsitutes one, and only one, character.

meh

Thanks for the reply .