2 Replies Latest reply: Dec 20, 2013 6:39 AM by Imen LAZZEM RSS

    Sales for top 2 values

      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

        • Re: Sales for top 2 values
          sujeet singh

          Se the sample is it what you want .

          Plz explain

            • Re: Sales for top 2 values

              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