Values that lies between two variables

[#1]

Hi,

Can you please help me to resolve this issue :

I have to list the years between a selected year Y and Y-1.

For example:

My selected Year is : 2013

The number of years on the past is : V_YearBack = 3

So i have to get : 2013 2012 2011 2010

Can any one help me ?

Thanks

[#2]

Hi Experts ,

I have now another question about this topic,

I am now trying to do this Aggr with the recommanded solution :

=Max(Aggr(Sum({$<Year ={">=$(=(max(Year ))-$(V_YearBack)) <=$(=(max(Year) ))"}>} Sales_EUR),Week_Extract))/1000 

But this ... doesn't work !!

Any help is welcome

Thanks

[matthias_v]

Hi,

See the attachment. I think this might be what you are looking for

[#4]

Yessssss .... It Works

Thanks a lot