1 Reply Latest reply: Jul 21, 2016 4:15 PM by Sunny Talwar RSS

    Set Analysis - need to always get a value for the max month

    Ken Hill

      Expression is this:




      I want this measure to always be the sum of the value for the most recent month in the data when the conditions X and Y are met.


      The above works except that it changes as date selections change.  It needs to remain static.  I'm sure that there is some syntax that I'm missing.