Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Se the sample is it what you want .
Plz explain
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