Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Create a calculated dimension if(len([Item ID]>5,[Item ID]) and check the option Suppress When Value Is Null
Create a calculated dimension if(len([Item ID]>5,[Item ID]) and check the option Suppress When Value Is Null
THANKS!