Using variable for Field value(Column) in Set Analysis

[satishsure]

I have variable called $vYearTotal. and I need to use in set expression to fetch for previous year.

=sum( {1<Year = {2015}>} $(vYearTotal) ).

I am trying to create new column using the above set expression.Not working for me.

[satishsure]

Yeah ..My requirement is like Second Column which is (Year=2015). But I need to Use the variable as field value for expression.irrespective of selection it should display the vYearTotal value for year 2015

=Sum( {1 <Year={2015}>}  $(vYearTotal) )

[sunny_talwar]

I am not sure what you mean my friend... can you please explain clearly