I have two table of sale data datewise one for 2015-2016 and another for 2016-2017.
In our retail chain bussiness some new location add or closed in 2016-2017. Now when i want to compare someone location with last year then what i do for sameperiod sale. Suppose xyz opened in 14 jun 2015 and sale is 1500000.00 and jun 2016 is 2800000.00 (14 jun2016 to 30 jun2016 is 1800000.00).
Now i want when compare with jun it should be 86.67%, and same period is 20.00%.
Please refer me some function/formula regarding this. Because i have 300+ location.
In our retail chain bussiness some new location add or closed in 2016-2017. Now when i want to compare someone location with last year then what i do for sameperiod sale. Suppose xyz opened in 14 jun 2015 and sale is 1500000.00 and jun 2016 is 2800000.00 (14 jun2016 to 30 jun2016 is 1800000.00).
Now i want when compare with jun it should be 86.67%, and same period is 20.00%.
Please refer me some function/formula regarding this. Because i have 300+ location.