Display the 2009 result value in list box2 when I click 2006 in list box1.

[gkcchowdary]

Hi

I want display the 2009 result in list box2 when I click 2006 in list box1 .how to implement.

[Anil_Babu_Samineni]

Please come up with Example?

If(GetFieldSelections(Year)=2006, Sum({<Year = {2009}>} Sales))

[effinty2112]

Hi Gattamaneni,

If you have a general need to show a year's summation for the year three years before the selected year try:

Sum({$<Year = {$(=-3+max(Year)}>}Sales)

Cheers

Andrew