Filter on line items that contain a specific text

Question

Hello, I have a module with many line items, and I want to filter on all line items that contain a specific word (e.g., "home"). How can I do that?

Thanks a lot!

JZCG · Answer

They are all numbers.

sai_anil_peddi · Answer

step 1 : create an line item subset with that module

step 2 : create new filter module with line item subset as dimension and add line item [ ex: home filter - format it in boolean ]

step 3 : write formulae in home filter line item (  IF FIND("home", NAME(ITEM(line item subset))) <> 0 THEN TRUE ELSE FALSE

step 4: apply that line item as filter

sample :

CommunityMember83188 · Answer

What format are the line items in the module?