to Exclude Particular Record

[SatyaPaleti]

Hi Friends,

I am having field called 'Name'

Record in the Name are Spell-Teleca,Spell-Indica,,Spell_Spanish,Spell-godrey,Spell-Inter

My requirement is

I want to show all the records in Name field Except Spell-Indica

Can i use Not match function

I am using Not Match(Name,'Spell-Indica') but it's not working can any one help to resolve this issue

THank You,

Satya

[Chanty4u]

1. Add Calculated Dimension

if(Not WildMatch([Spell], 'Teleca_*', 'Indica_*', 'Spanish_*'),[Spell])

2. Check "Supress when value is null"

  try abve

[Chanty4u]

chk below link

How to exclude the field values?

[tamilarasu]

Try,

If(Not Match(Name,'Spell-Indica'),Name)

[#5]

if(name<>'Spell-Indica',Name)

[Peter_Cammaert]

For straight tables and all objects that perform some kind of aggregation, use set analysis. You'll get better performance. For example, an expression like

=sum({<Name -= {'Spell-Indica'}>} Sales)

won't calculate results for value 'Spell-Indica' and because NULL values are suppressed by default, will not show the row for that value.

[HirisH_V7]

Hi,

=If(Name='Spell-Indica',Null(),Name)

• Supress Null Values for your Dimension

HTH,

Hirish

[ahmar811]

try this

if(wildmatch(Name,'Spell-Indica')=0,Name)

hope this help you

Thanks & Regards

Ahmar Ansari

[panipat1990]

Hi Satya,

             Try This

Load

        Name

From

(ooxml, embedded labels, table is Sheet1)

Where Name <>  'Spell-Indica';

[HirisH_V7]

I agree with pcammaert  go with set analysis exclusion for better performance of your report .

-Hirish