Filter certain rows

[Kallis]

Hi

I have a requirement based on which I need to remove certain rows from the final output. From the below table, I need to leave out all those cost elements that starts with 5 and pick the ones that starts with 6.

I do not know whether this can be achieved using the Filter Tool. Kindly help

Cost Element	Posting Date	Test 1
520323	24-06-2024	Test
520323	24-06-2024	test
520323	24-06-2024	Test
520323	24-06-2024	Test
520323	24-06-2024	Test
520323	24-06-2024	Test
520323	24-06-2024	Test
520323	24-06-2024	Test
602024	12-06-2024	t
602024	12-06-2024	t
602024	28-06-2024	t
602024	28-06-2024	t
602024	12-06-2024
602024	28-06-2024

[alexnajm]

A StartsWith function in a filter tool should work well for your use case

[alexnajm · Accepted solution]

StartsWith([Cost Element], “6”)

[Kallis]

@alexnajm I thought about such a parameter but it is not there

[Kallis]

Sorry @alexnajm 

You meant a function. I just saw that

[Kallis]

Thanks @alexnajm 

It works. I will mark this as solution