calculated dimension to filter values

[surajap123]

Hi All,

I am trying to create a calculated dimension to show only few values in straight table.

In the Name field, I want to filter any value starting with *classic. Eg- *Classic Edu, *Classic Tours, *Classic Agen etc..

But the below expression is still showing them. It filters out the above values only when i put full name like *Classic Edu. But i want to filter out all when Name start with *Classic in my straight table.

Below is the calculated dimension i am using-

=if(Name<>'*Classic*',Name)

[maxgro · Accepted solution]

if(wildmatch(Name, '*classic*'), null(), Name)

[senpradip007]

Use  if(not WildMatch( Name,'*Classic*'),Name) and check "Suppress When Value Is Null"

[its_anandrjs]

You can try with

if(wildmatch(Name, '*classic*'), 0, Name)

Or

if(wildmatch(Name, '*classic*'), null(), Name)

And Check the "Suppress when value is null" option in the chart

[amit_saini]

Hi Suraj,

Try this:

I'm taking example of year, suppose you want to display only 10,11 and 12 than use this

=if(match(Year,'2010','2011','2012' ),Year)

Thanks,

AS

[surajap123]

Thanks everyone !!