Filter on line items that contain a specific text

JZCG
edited December 2022 in Modeling

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!

Answers

  • CommunityMember83188
    edited December 2022
    What format are the line items in the module?
  • sai_anil_peddi
    edited December 2022

    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 :

     

    sai_anil_peddi_0-1671549090494.png

     

    sai_anil_peddi_3-1671549192985.png

     

    sai_anil_peddi_2-1671549142059.png

    sai_anil_peddi_4-1671549221763.png

    sai_anil_peddi_5-1671549269447.png

     

     

     

  • They are all numbers.