Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
1. Create 2 variables:
max1=max(Year)
max2= max(Year)-1
2. Trigger -> Select in field:
Year
='(' & $(max1) & '|' & $(max2) & ')'
See my attached sample.
1. Create 2 variables:
max1=max(Year)
max2= max(Year)-1
2. Trigger -> Select in field:
Year
='(' & $(max1) & '|' & $(max2) & ')'
See my attached sample.