Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have year field something like this FY stands for full year and MY stands for Mid year.
Period, PeriodActual
FY2015,20152
MY2015,20151
FY2014,20142
MY2014,20141
FY2013,20132
MY2013,20131
To get current year, i use =Max({<Period=>} PeriodActual), but it gives me 20152 not period.
i want current year and previous year calculation to show period
current year=fy2015 and previous year fy2014
help plz
hi sunny,
one more help attached the same file with a chart, what i want is
if i select year fy2015, the chart should show sales for fy2015,fy2014,fy2013
if i select year my2015, the chart should show sales for my2015,my2014,my2013
how can i do this? thanks in advance
Checking now
Try this expression:
Sum({<Period = {"$(=Left(Period, 2) & '*')"}>}sales)