I have to Dynamically calculate average sales for last 5 weeks last year , i.e
Current week = 40 and current year 2017
so I want
last year 5 weeks average = week 41(2016) to week37(2016)/ 5
same way every week I am able to dynamically caluclate average to compare with sales
Please advice me
I'm sorry, but I need a little more information how to calculate the measure you require, can you please explain how you "find" the timeframe of the 5 weeks for the last year?
What is your expectation if the current week is the 2nd week of the year, would you expext, that the time frame
This is important information how to determine the measure to calculates the average sales for the last 5 weeks last year.
Hey, can you please explain how you did define the timeframe for the 5 weeks last year?