Rolling back 7 weeks From current Week and Rolling Forward 4 weeks?
Hello , i want to calculate the Sales for the 7 weeks back from the curr week and also 4 weeks forwards including the curr week?
Dimension is week and i want to show sales and targets week wise such that if i select any week or by default the curr week then it must also gives me rolling back 7 week sales and targets and 4 weeks forward sales and target .
And in case of curr week i.e. latest week whose data is available then in that case i will show targets for Rolling 4 weeks and rolling back 7 weeks for sales and targets.