I am selecting from two different states (calculated dimensions (Field1 - State1, Field2- State2)) and my Date field is in default state. I have to take the max date from that date field which. How do i tell that my my date field's state?
See, the below expressions: the one with IF works fine. I want the same with Set Analysis.
Sum({State2+State3}if(Date=vUIMaxDate,Rate))- OK
Sum({State3+State2<[Date]={'$(vUIMaxDate)'}>}Rate) - Wrong (probably because i have to specify somehow that Date is in default state).
Thanks Kumar. I am still not clear(though not yet took a deep look) how to implement my scenario as it contains a variable in the default state. i will still take a close look at the discussion you referred.
