Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have like
load * inline
year,sales
2000,100
2001,200
2002,300
2003,400
2004,500
2005,600
2006,700
2007,800
];
my req is 1) if click on year 2001 then i want to see the sales for 20001,2002,2003? (from current selection to 3 yers )
2) if click on year 2001 then i want to see the sales for 20002,2003,2004?(excluding current selections)
Hi,
You can try this with the GetFieldSelections() function for get the selection values and try like
1. =sum({<year = {'>=$(=GetFieldSelections(year)) <=$(=GetFieldSelections(year)+2)'}>}sales)
2. =sum({<year = {'>=$(=GetFieldSelections(year)+1) <=$(=GetFieldSelections(year)+3)'}>}sales)
Regards
Anand
for this
sum({$ <year={">=$(=max(year))<=$(=max(year)+2)"}>} sales)
sum({$ <year={">=$(=max(year)+1)<=$(=max(year)+3)"}>} sales)
Hi,
You can try this with the GetFieldSelections() function for get the selection values and try like
1. =sum({<year = {'>=$(=GetFieldSelections(year)) <=$(=GetFieldSelections(year)+2)'}>}sales)
2. =sum({<year = {'>=$(=GetFieldSelections(year)+1) <=$(=GetFieldSelections(year)+3)'}>}sales)
Regards
Anand
Hi,
If you use this expression for both query will be better
1. =if( GetSelectedCount(year) = 0,Sum(sales),sum({<year = {'>=$(=GetFieldSelections(year)) <=$(=GetFieldSelections(year)+2)'}>}sales))
2. =if(GetSelectedCount(year) = 0,Sum(sales),sum({<year = {'>=$(=GetFieldSelections(year)+1) <=$(=GetFieldSelections(year)+3)'}>}sales))
Regards
Anand