selection year?

[#1]

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)

[maxgro]

for this

sum({$ <year={">=$(=max(year))<=$(=max(year)+2)"}>} sales)

sum({$ <year={">=$(=max(year)+1)<=$(=max(year)+3)"}>} sales)

[its_anandrjs · Accepted solution]

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

[its_anandrjs]

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