Sum - Select - Year less then

[#1]

Hello.

I Have a table:

Year	Value
2001	1
2002	2
2003	3
2004	4
2005	5
2006	6
2007	7
2008	8
2009	9
2010	10

I must create a bar chart, include only 5 years: 2001, 2002, ..., 2006.

I use a sum with select: sum({<Year={XXX}>}Value)

What i must insert instead XXX?

<=2006 not work

Thank you.

[#2]

Alessandro,

for example, I create variable: SetYearMax

How i can insert this variable in the formula?

[alexandros17]

sum({<measureName={Opex, Expenditure}, budgetName={"Approved"}, Year={'<=$(SetYearMax)}>}quantity)

let me know

[#4]

Great!

Thank you very much

[#5]

Allesandro, one more question.

Where is I do mistake?

sum({<measureName={Opex, Expenditure}, budgetName={"Approved"}, Year={'<=$(SetYearMax)'}, Year={'>=$(SetYearMin)'}>}quantity).

I want create interval. From year 2002 to 2008 or another.

[alexandros17]

sum({<measureName={'Opex', 'Expenditure'}, budgetName={'Approved'}, Year={'>=$(SetYearMin)<=$(SetYearMax)'}>}quantity)

[#7]

O! I understand. Thank you very much.

I try in first: Year={'>=$(SetYearMin)', '<=$(SetYearMax)'}.