Calculating sales growth

[Anonymous]

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,

[Anonymous]

Wow! I have not used script much. Just to import data. But this looks really great!

I think I will have to understand this but it would solve my purpose. Thanks a ton!