5 Replies Latest reply: Feb 23, 2012 4:49 AM by j i RSS

    Month to Month growth

    Sandip Patel

      Hello community,

       

      I have a pivot table in below format and I want to calculate the % growth based on this month vs previous month.

       

      Any one has a clue how to achieve this in Qlikview in the required pivot table format?

       

       

       

       

      MonthFinYear20052006200720082009201020112012
      Apr03,5874,0544,6692,0136,3575,7996,568
      May05,2784,8174,6104,5157,0146,7597,670
      Jun03,9913,5234,0444,9527,0468,1096,819
      Jul03,7393,3314,2044,3326,2806,8755,994
      Aug3,0674,3474,3525,4394,2747,4096,9006,561
      Sep3,3223,6454,5456,6994,8235,7985,9217,329
      Oct4,0074,6434,6465,8885,5356,3946,6166,800
      Nov5,4324,7796,6234,5478,0737,1478,2237,553
      Dec6,8127,8918,3127,1367,53610,3649,53911,916
      Jan5,5456,1565,2036,7086,6147,2838,4579,171
      Feb4,0294,9493,9053,7405,6465,5485,2981,559
      Mar3,5624,5975,6454,9734,8756,2305,5240

       

      Thanks & Regards,

      Sandip Patel