Current year and previous year

[gauthamchilled]

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

[gauthamchilled]

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

[sunny_talwar]

Checking now

[sunny_talwar]

Try this expression:

Sum({<Period = {"$(=Left(Period, 2) & '*')"}>}sales)