I have taken YEAR field in list box,it is having 2004 to 2014 sales.But i need 2007 to 2011 sales with out using set analysis.

[#1]

Can any one plz share the answer

[d_pranskus]

Use something like SUM({<Year -= {">=2007<=2011}>} Amount)

[#3]

Hi Darius

    I need with out using set analysis

[d_pranskus]

Why can't you use set analysis?

[#5]

As per my requirement i have to use only variables

[oknotsen]

Indeed.

And I already asked why not.

[d_pranskus]

You can use the following SUM(IF(Year >= 2007 AND Year <= 2011, Sales)).

[Anonymous]

Hi rgv,

If you don't mind me asking,are you sure,should not use set analysis or hard code data in set analysis,instead use variables in set analysis.

Regards

Neetha

[neha_sri · Accepted solution]

Hi rgv,

You can use this expression.

in General>field>edit, write this expression

if(Year>=2007 and Year<=2011,Sale) . It will work

[Karthik3]

Can you give us one solid reason why you don't want to use set analysis?