Issue in list box for years

[#1]

Hi maxgro , swuehl,

Can someone please tell me the expression for excluding past three years from the list box dynamically.

[sunny_talwar]

Exclude past three years or include them?

[sunny_talwar]

Exclude may be this:

If(not Match(Year, Max({1}Year), Max({1}Year, 2), Max({1}Year, 3)), Year)

Include:

If(Match(Year, Max({1}Year), Max({1}Year, 2), Max({1}Year, 3)), Year)

[ramoncova06]

this is to only show the last three years

aggr(only({<Year = {">=$(max(Year,3))"}>}Year),Year)

this is to exclude the last three year

aggr(only({<Year = {"<=$(max(Year,3))"}>}Year),Year)

[antoniotiman]

Hi,

Try

=Aggr(DISTINCT  If(Rank(TOTAL -YEAR) > 3,YEAR),YEAR)

Regards