3 Replies Latest reply: Jun 15, 2017 1:41 PM by Vishnu Chakrakishore RSS

    Toggle between Filterpane/Expression dimensions using Pick/ Match

    Vishnu Chakrakishore

      All,

       

      I have a question.

       

      We have a Value_Selector field in the DM with these 3 values 'A','B','C'.

       

      We also have 3 separate flags in the DM named 'A','B','C'. The values for these flags are 0 and 1 only.

       

      We have an expression of the form

       

      Sum(Sales * if(Value_Selector='A',[A],

                             if(Value_Selector='B',[B],

                                 if(Value_Selector='C',[C], [A] ))))



      Can I use a Pick/Match for this?


      BIG Caveat: What if the user selects multiple values. (Like A and B or All of them)

       

      cleveranjos swuehl