Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Don't use equal sign like?
{<Month = {"<=$(=Max(Month)-1)"}>} instead use like below
{<Month = {"<$(=Max(Month)-1)"}>}
can u plz suggest how to handle this at dimension level
May be this?
If(Month < AddMonths(Max(TOTAL Month),-1), Month)
Note - Suppress when value is null should be checked.
Thanks Anil
But this has not worked.
Thanks
Will you able to provide sample
PFA
Seems working?
=If(Month_Turns < Max(TOTAL Month_Turns), Month_Turns)