CurrentYear MaxMonth vs LastYear MaxMonth

[#1]

Hi Community

I have difficulty to get the result that i want. Below is the result table, basically what i want is to show the Last Month sales amount for each year. The last month for 2008-> Dec, 2009->Dec, 2010-> Jun. Attached with the data and qvw. Thanks in advance.

Year	CurrentYear	Last year
2008	136,136	0
2009	105,083	136,136
2010	86,978	105,083

[#2]

Anyone can help me on this?

[kushalthakral]

Hi John

Will try with the data provided with you and revert you back with solution

Regards

Kushal T

[kushalthakral]

Hi John

First you convert months in number by using num(month(Date))

and then use the following expression

=sum({<MonthNo={$(=(Max(MonthNo)))}>}Sales)

[#5]

Hi Kushal

I have tried but it doesn't give me the correct result.