This content has been marked as final. Show 3 replies
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)