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

Thu, 21 Jul 2016 18:23:40 GMT

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!

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

sunny_talwar — Thu, 21 Jul 2016 20:15:10 GMT

Try this:

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