13 Replies Latest reply: Mar 4, 2016 3:45 PM by Sunny Talwar RSS

    Combining multiple conditions on a measure

    akshata tare

      I have a measure which has to show data based specific accounts and sum it all up to the date selected in filter.

      I have created this so far and I don't understand how to combine these two expressions in the same measure

       

      1. Sum({$<account = {1,2,3,}>},amt)

      2. Sum({$<year = {=max(year)}>},amt)

       

      I tried creating variable for one of the conditions and still couldn't get this to work. Can someone please correct me.