Update a filter based on picklist

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

Best 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

  • 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

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

     

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

    Although my bad, I missed that point.

  • This worked beautifully. Thank you!