DOUCUMENT TRIGGER

[AVINASH22]

In my dashboard i have 5 years of data.Requirements is that on open the dashboard, recent year data and previous year data is to be selected...so how to implement this by using trigger.

[Claudiu_Anghelescu · Accepted solution]

1. Create 2 variables:

  max1=max(Year)

   max2= max(Year)-1

2. Trigger -> Select in field:

 Year

='(' & $(max1) & '|' & $(max2) & ')'

See my attached sample.