3 Replies Latest reply: Apr 16, 2013 11:55 PM by Yusuf Ali RSS

    Month to Month comparison in Metrics

    kranti banala

      Hi

       

      I am looking for an output something like below.

       

      can you share some ideas how I can calculate the difference in % between the current month and the previous one. I want this comparision for all the months in the table

       

      Attrb1
      janfeb
      march
      A5054+4%60+6%
      B7073+3%79+6%
      B8089+9%85-4%

       

      Thanks,

      Kranti

        • Re: Month to Month comparison in Metrics
          Yusuf Ali

          Hi ,

              

          Try to have the Data in Excel as

          Attrb1janfebmarch
          A505460
          B707379
          B808985

           

          Then try the below code

           

          Tab:

          CrossTable(Month,Sales)

          LOAD  Attrb1,

               jan,

               feb,

               march

          FROM

          [....................................]

          (biff, embedded labels, table is Sheet4$);

           

           

           

           

          Tab1:

          NoConcatenate

          LOAD Attrb1, Month,if(Attrb1=Previous(Attrb1), if(Previous(Sales)<>Null() , Sales-Previous(Sales))) as Differece

          Resident Tab;

           

           

          DROP Table Tab;

           

          Please reply me for the same .

           

           

          Regards

          //Yusuf