Don't show hidden data in listbox

[Sxbbb]

At first I had hidden the type= MTN CMK using code : =If(WildMatch(Type,'ME','MTN','NORMAL','TEST ME','TEST CONFIRM'),Type)

Result :
 

But in the table still shows the data that type = MTN CMK

Want to provide information that Type= MTN CMK does not show any information.

Result:

Display all categories without selecting them in the list box.

[BrunPierre]

Consider using source filters to restrict the volume and type of records transferred from your source to your model, allowing you to concentrate only on the necessary data sets.

Like this, perhaps.

Where Match(Type,'MTN CMK')=0;

[Sxbbb]

The first sheet doesn't show the MTN CMK, but the second sheet requires only the MTN CMK.

[BrunPierre]

I think a workaround would be to use buttons or triggers (on activate sheet).

String Search: ='(' & Concat( {<Type=-{'MTN CMK'}>} Distinct '"' & Type & '"','|') & ')'

[Sxbbb]

Is there another way to get the data value of Type = MTN CMK without showing it in the list box (green)

I need it like this without displaying information of Type= MTN CMK .

[MayilVahanan]

Hi

You can bring one more field with like below and use "Type1" in the first sheet [both filter and table].

If(WildMatch(Type,'ME','MTN','NORMAL','TEST ME','TEST CONFIRM'),Type) as Type1

[Sxbbb]

results like this But I want the data that Type = MTN CMK not show all tables.