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:

       

      Sum({1<YEAR_MONTH={'$(=MaxString(YEAR_MONTH))'},METRIC_NAME={'X'},COMPANY_NAME={'Y'}>}METRIC_QUANTITY)

       

      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.

       

      Thanks!