9 Replies Latest reply: Oct 19, 2012 1:33 PM by Stefan Wühl RSS

    Help with Day and previous year

      Hello,

       

      Sales table contains sales, day, store, etc

      Another table has the day and the equivalent day of previous year. Fi: 2012 October 10 is equivalent to 2011 October 14; 2012 September 28 is equivalent to 2011 September 30 and so on.

      When I want to know sales from one period of time, some days one month, etc vs the previous year I solved it with set analysis and concat; it works with city, region, store, brand, etc. But  with Day as dimension it doesn’t work

       

      How can I get this table?:

      Day

      Sales

      Sales previous year

      %

      28/09/2012

      100,00 €

      110,00 €

      90,91%

      29/09/2012

      120,00 €

      98,00 €

      122,45%

      30/09/2012

      140,00 €

      136,00 €

      102,94%

      In this table, first row, Sales previous year should be the sales of 2011 September 30 because is the equivalent day of 2012 September 28

       

      Any help

       

      Thanks

        • Re: Help with Day and previous year
          Gysbert Wassenaar

          This can be done with set analysis. You can see on the tab Set Analysis - Static in the attached ytd-set-analysis.qvw how this is done.

            • Re: Help with Day and previous year

              Thanks but it is not that I am looking for. I am going to add some explanation in order to try to explain it a little bit more

               

              Sales table:

              Day

              Sales

              30/09/2011

              110,00 €

              27/09/2011

              98,00 €

              22/09/2011

              136,00 €

              ……

              ……

              28/09/2012

              100,00 €

              29/09/2012

              120,00 €

              30/09/2012

              140,00 €

               

              Equivalents Days:

              Day

              Same day previous year

              28/09/2011

              29/09/2010

              29/09/2011

              23/09/2010

              30/09/2011

              28/09/2010

              …….

              ……

              28/09/2012

              30/09/2011

              29/09/2012

              27/09/2011

              30/09/2012

              22/09/2011

               

               

              And the graphic (table) that I want to show is the showed in my previous post

              Day

              Sales

              Sales previous year

              %

              28/09/2012

              100,00 €

              110,00 €

              90,91%

              29/09/2012

              120,00 €

              98,00 €

              122,45%

              30/09/2012

              140,00 €

              136,00 €

              102,94%

               

              Thanks for your help