Find a list member based on boolean check


I have a scenario module dimensioned by scenario. And a line item formatted as boolean. Based on the selected boolean check, the  corresponding scenario should appear in a 'scenario' formatted line item in a module with no dimensions



  • I think dependent drop-down might be your answer here of a sort.

    Might just need to have an additional line item in your 2nd module to make the thing work and use the single dimension.

  • I would do an if statement, IF Boolean? then Bring the line item scenario else blank. 


    I think that should work. 

  • Thanks deimar. This works. I changed my summary settings in the source and it worked