Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have listbox year
year:
2000
2001
2002
2003
2004
2005
2006
2007
2008
1)when i click on 2002 i want sales from 2002 to 2008
2) when i click on 2004 i want sales from 2000 to 2004
3)when i click on any year and after clearing the selections i want see sales for 2002 and 2003 ?
Hi,
1st expression Like this,
Sum({Year={">=$(=max(Year))"}}Sales) // This will give you sum of sales from selection Month to till Last
2nd Expression Like this,
Sum({Year={"<=$(=max(Year))"}}Sales) // This will give you sum of sales from start to current Selection Year.
Regards
Hi,
What is logic behind it?
Can you explain in details?
Regards
1)first one is when i selecet any year i want sales from that selection year to till last
2)second one is when i select for example year 2004 i want see the sales from 2000 to 2004
3)by default i want see selection for 2003 and 2004 if i click on 2005 i want see for 2003,2004 and 2005 when i clear this selection i have to see selection for 2003 and 2004 it should not clear .
give me these three expressions
You can't create too many types dependent selection on a single list box you can create a single based dependent selection you can follow this link to give you the desired results
hi ra bhanu ekkadunnavu
Better you create all three conditions seperatly and store in a variable and the call them using a button (launching a action).I hope that will work.
REgards
KC
Hi,
1st expression Like this,
Sum({Year={">=$(=max(Year))"}}Sales) // This will give you sum of sales from selection Month to till Last
2nd Expression Like this,
Sum({Year={"<=$(=max(Year))"}}Sales) // This will give you sum of sales from start to current Selection Year.
Regards
Hi,
3rd Expression Like this,
if(getSelectedCount(Year)=0,
Sum({Year={"2003","2004"}}Sales),
Sum({Year={"2003","2004"}}Sales)+Sum({Year={"$(=max(Year))"}}Sales))
Regards