3 Replies Latest reply on May 29, 2016 2:10 AM by sushma.koyi

    Creating a table of cumulative monthly growth from daily growth

    Yan Wu
    Yan Wu Nov 17, 2015 9:41 AM

      Hello,

       

      I have a sample data of daily growth rates from sales from 3 different stores (unfortunately these are not real growth rates of these stores).

       

      I can create a cumulative growth chart very simply using:

      (1+sum([Growth]))*(1+PREVIOUS_VALUE(1))-1

       

      I would like to create a table that shows the month over month growth rates.  Ideally, it would be 3 sections for the 3 stores, Year going down the rows and months across the columns.

       

      I tried messing with it, but I cannot get the calculations to work.

       

      Does anyone have any ideas on how to do this?