Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one filed that Year: 2000
2001,
2002
2003
...
...
...
and so on 2010
Based on the user selection previous years data needs to be displayed.
for example: user selects 2003 so it needs to be displayed the previous years data means 2001 and 2002 data should get displayed.
if user selects 2006 , needs to get displayed 2001 to 2005 data not all , only the previous years data based on selection
Can you please help me on it.
Please find sample app , and below expression will help you
sum({<Year={">=$(=min({1}Year)) <$(=GetFieldSelections(Year))"}>}Amount)
Please check if this works
Hi,
1.When user select 2003, only show 2001, 2002? no 2003?
2.When user select 2006, only show 2001 to 2005? no 2006?
3.If user select more than 1 year, like 2003 and 2004, or 2003 and 2006, what year should be show?
Aiolos Zhao
PFA
Sum({<Year={">=$(=Min({1}Year))<$(=Max(Year))"}>} Sales)
Please find sample app , and below expression will help you
sum({<Year={">=$(=min({1}Year)) <$(=GetFieldSelections(Year))"}>}Amount)
Hi ,
If user select more than 1 year, like 2003 and 2004, or 2003 and 2006, what year should be show?
..If user selects 2003 and 2004--only 2001 , 2002 for 2003 selection and 2001,2002,2003 for 2014 selection
Please check if this works