Sales for top 2 values

[#1]

Hi,

I am trying to get the Sales for the top 2 values of a variable that i called Elapse for the last 2 years ( If i select Elapse=(-6) and Year=2012) i want to see in my table :

Year     Elapse Sales

2012     -6          sum of sales

2012     -9           sum of sales

2011     -28        sum of sales

2011    -36         sum of sales

Please find attached my qvw.

thanks for your Help

[sujeetsingh]

Se the sample is it what you want .

Plz explain

[#3]

Hi,

i am  not looking for the sum of Elapse, i want to see the Sum of sales for top 2 Elapse Values and compare it with the last year. How can i add this condition in my set analysis expression in table (Top 2 Sales by Year / Elapse).

Please find below an example :

If i select Elapse=(-6) and Year=2012) i want to see in my table : 

Year     Elapse Sales

2012     -6          sum of sales

2012     -9           sum of sales

2011     -28        sum of sales

2011    -36         sum of sales

Thanks a lot for your help