Update a filter based on picklist

BahalR
BahalR
in Modeling

I have a Module 1 with 2 dimensions. List A and List B. I have a line item in the module formatted as numbered List C which the users can select. 

 

I have a SYS module for List C. I would like to create a boolean in my SYS module that gets checked for any member of the list that a user selects in module 1

Tagged:

Best Answer

  • ankit_cheeni
    ankit_cheeni
    Answer ✓

    Hi @BahalR 

     

    Create a boolean line item in Module 1 that is always true. Something like this:

    ankit_cheeni_0-1659595729981.png

    Fruits is your List C. In the system module for List C (Fruits in my example), create a line item with this formula:

    ankit_cheeni_1-1659595879370.png

     

    Let me know if what you need is different

     

     

     

Answers

  • rishabh01
    rishabh01

    Hey @BahalR ,

    I have a solution, can you just confirm that your SYS module for List C is also dimensioned by List A and List B?

    Thanks,

    Rishabh

  • Anurag0911
    Anurag0911

    Hey, Rishabh it is not recommended to have multiple lists in a SYS Module.

     

  • rishabh01
    rishabh01

    Hey anurag you should mention SYS module as well, in other modules you can have multiple lists.

    Although my bad, I missed that point.

  • BahalR
    BahalR

    This worked beautifully. Thank you! 

Categories