Straight table - limit selection

[#1]

Hi guys,

Thanks for looking!

I have a straight table where I would like to only show those items that have string lenth of more than 5.

For example, now I have

Item ID	Qty	Sales	Cost
Total	10	100	50
GEF	5	50	25
ABCABC	3	20	10
1234567	2	30	15

I would like to exlude "GEF" from this stragiht table.

How can I do this?

I found a way to exclude it by adding a len(Item ID) column to my load statement and exluding all short items IDs in a list box.

However this way my current selections box gets "dirty" with selections that I don't want to show to the end User.

Is there a better way to limit raw data provided for straight table output?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Create a calculated dimension if(len([Item ID]>5,[Item ID]) and check the option Suppress When Value Is Null

[#3]

THANKS!