Current year previous 3 months

[#1]

Fin_Year	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2011	45000	44000	46000	45000	47000	48000	49000	40000	41000	42000	44000	45000

this is my data.

i want to show this when i select August 2011

Jun	Jul	Aug
48000	49000	40000

and when I select April this should come.

Feb	Mar	Apr
44000	46000	45000

[rajni_batra]

try month>= addmonths(month,2)

[tresesco]

Have a look at the attachment. Hope this helps. (Courtsey: sparur)

Regards,

tresesco

[#4]

you can also try this:

sum({<date = {'<=$(=MonthEnd(makedate(fin_year,month,1)))>=$(=addmonths(makedate(fin_year,month,1),-2))'}, month = >}field)

[sivarajs]

Try the attached sample

[#6]

Sivaraj you sample will only work when your Months are numbers!! But in irfankhanirf case you have the Monthnames.

regards,

MT

[sivarajs]

Check out this sample