10 Replies Latest reply: Dec 20, 2017 2:45 PM by Rahul Joshi RSS

    Calculating sales growth

    Rahul Joshi

      Hi Everyone,

       

      I want to calculate semester on semester sales growth(2017S2-2017S1) as well as YoY sales growth(2017S2-2016S2).

      NOTE: I want to make it dynamic i.e. if the data updates to 2018S1 sales the code should automatically consider the added semester as the latest one and give the sales growth accordingly.

       

      I cannot figure out any logic for it. Please guide me towards the desired output.

       

      Attached is a sample data. Thanks.

       

      Best Regards,