Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Exclude past three years or include them?
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)
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)
Hi,
Try
=Aggr(DISTINCT If(Rank(TOTAL -YEAR) > 3,YEAR),YEAR)
Regards