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

    Toggle between Filterpane/Expression dimensions using Pick/ Match

    Vishnu Chakravaram



      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='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)


      cuv swuehl