1 Reply Latest reply on Nov 17, 2016 7:02 AM by lenaic.ridinger

    Growth Rate for a Selected time Range

    santosh kalvemula

      Hi All,

       

      My requirement is to show the Sales growth for the products in the below scenario

       

      I've the data from Jan 1st 2016 on a daily basis and i want the growth rate to be calculated at month level

      1. Growth Rate by considering the first sales value available (Ex - If furniture didn't have the sales in first 2 months, it has to calculate the growth rate from March)

      2. What are all the products that had an "n" amount of increase in their sales for the selected time period

      3. How much of this Product growth has contributed 

       

      Appreciate your quick help and thank you in advance