How to create alternative filter?

[#1]

Hello!

Is there a way to create a filter that shows only some values, without deleting any of the data from the table. The data is needed, but I need a filter that does not show all the values.

Like if I had a dimension values with I could filter:

A

B

C

But I would like to user have only chance to filter with these:

A

C

And the list is of course with ~100 of values.

There is a workbook attached also if someone want's to play around.

Cheers,

Niko

[#2]

This was already answered !

[Anonymous]

Hi Niko,

You can add a calculated dimension and use the same expression than the one in the listbox

Just be aware of check the supress when value is null option to take out the rows that you don't want to display.

Regards,

-- Karla

[#4]

Yes, thank you !

Cheers,

Niko