thanks

[#1]

               Thanks

[#2 · Accepted solution]

do u want remove the data from chart?

if yes, then create the calculated dimension instead of name dimension in chart.

if(Right(Name,4)<>'n.a.',Name)

do u want remove the data in script part?

Load * from ur table

where Right(Name,4)<>'n.a.';

Regards,

Kabilan K.

[#3]

already tried dude , but not working ...
unfortunately getting nulls in the report .

[somenathroy · Accepted solution]

You may try below where with LOAD statement:

Where SubStringCount(Name,'n.a.')=0;

Regards,

som

[#5]

Hi Satti,

You can use below where clause. Hope your problem will be solve.

where not wildmatch(NAME,'n.a.*')

Thanks

Garry