Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have a graph that is showing data of current and last year at a same time.
but as im not sure about last year data so i just want this last graph will be valid from starting from this year ??
and it will not include the data of last year ??
Hi,
Try like this
=Sum({<Month=, Date=, Year={'$(=Max(Year))'}>} Sales)
Note: Replace Month, Date, Year with your actual field names.
Regards,
Jagan.
Hi yougit try below
1. Current Year
=Sum({$<Month=, Date=, Year={$(=Only(Year))}>} Sales)
or
=sum({<Month=, Date=, Year={$(=max(Year))}>}Sales)
2. Previous Year
=Sum({$<Month=, Date=, Year={$(=Only(Year)-1)}>} Sales)
or
=sum({<Month=, Date=, Year={$(=max(Year)-1)}>}Sales)
Regards
ASHFAQ
Hi ,
i'm already using this expression.
sum
({<FiscalYearName={'$(vLFY)' }>}Sale)*688.17/10000000000+sum({<FiscalYearName={'$(vLFY)' }>}(BONDED_SALE+DUTY_PAID_SALE)*688.17/10000000)
but wat i want my last year graph will show data from 2014-2015 onwards . not before that
Hi,
Can you post your sample application?
Regards
ASHFAQ
please suggest smething ?
Then you can limit the same using condition in Dimension itself..
can u give some example ??
i'm using fiscal month as a dimension?/
Are you displaying Rolling months like Last april to this march ?
yes