Not getting added sum when selecting two financial year or any selection.

[#1]

When I select two financial year am not getting the sum of both year total complaints or fbc complaints or in any of the  box the sum is not coming, only the highest year value is coming. the expression used in total complaints is :

Sum({<Year={$(=Max(Year))},TRANDATE={'>=$(vStartDate)<=$(vMonthEndDate)'},Quarter=,HalfYearFin=,Month=,Day=>}CMP_CUSTOMER_CALL_COUNT)

where vStartDate is :=If (GetSelectedCount(Month)=0 And GetSelectedCount(Quarter)=0,MonthStart(Date(Max(Date))),Date(Min(Date)))

and vMonthEndDate is :=MonthEnd(max(Date))

the default view without any selection should shows current month data only in the 6 boxes, and when selected any particular financial year or Months the total for the selection should come in all the boxes. The box is a gauge and straight table selected in fast type change in the general tab of a chart.

Can anyone please help me in solving this. Please check the sample as attachment to get some idea.

[jonathandienst]

This part is selecting the latest/selected year:

Year = {$(=Max(Year))

Change to

Year = (">=$(=Max(Year) - 1) <=$(=Max(Year))")

[#3]

With the above expression I am getting 0 as result.

[#4]

Thank you Jonathan for your reply, but with the above expression am getting 0 as result.

[jonathandienst]

I suggest you upload a sample qvw containing some representative data.

[#6]

Thanks for the reply Vineeth, but still after removing Year={$(=Max(Year))} when am selecting two financial year its showing value for the highest year only.