showing data till max (month)-1

[kishorj1982]

Hi All,

I have data from June to December.

if December is displayed need to show data till November.(Jun,Jul,Aug,Sept,Oct,Nov)

if Jan displayed need to show data till December.(Jun,Jul,Aug,Sept,Oct,Nov,Dec)

Can you please suggest how to handle this at dimension level.

Provided is the month field.

Thanks

[Anil_Babu_Samineni]

Don't use equal sign like?

{<Month = {"<=$(=Max(Month)-1)"}>} instead use like below

{<Month = {"<$(=Max(Month)-1)"}>}

[kishorj1982]

can u plz suggest how to handle this at dimension level

[Anil_Babu_Samineni]

May be this?

If(Month < AddMonths(Max(TOTAL Month),-1), Month)

Note - Suppress when value is null should be checked.

[kishorj1982]

Thanks Anil

But this has not worked.

Thanks

[Anil_Babu_Samineni]

Will you able to provide sample

[kishorj1982]

PFA

[Anil_Babu_Samineni]

Seems working?

=If(Month_Turns < Max(TOTAL Month_Turns), Month_Turns)