Calculated Dimension for MAX monthyear

[jeckstein]

Hi,

I need to create a calculated dimension for the max(Month year) where future flag=0.

Example: today is 11/6/2016. Future flag is on 11/7/2016. I need a calculated dimension for date range 11/1/2016-11/30/2016.

But if I select Monthyear Oct-2016. I need a calculated dimension for date range 10/1/2016-10/31/2016.

I have been using set analysis like this (If this helps)

    {<MonthYearID={$(=max({<FutureFlag={0}>}MonthYearID))}>}

Thanks in advance!!!

[MK_QSL]

Provide sample data or sample app to work..

[Anil_Babu_Samineni]

Set Analysis, You are expecting this?

If(MonthName = GetFieldSelections(MonthName), Sum({<DateField = {'>=' & MonthStart(DateField) '<=' MonthEnd(DateField)}>} Sales))

[dineshm030]

Hi,

May be this expression will be helping to you....

{<MonthYearID = {">=$(MonthStart(MonthYearID )<=$(MonthEnd(MonthYearID )"}>}