Find my approach as reference below and stored in attached workbook version 9.3 located in the original thread
1. Selected week: IF DATEDIFF('week',[Date],[Week Ending Parameter])=0 then [Units] END
2. Selected week -1: IF DATEDIFF('week',[Date],[Week Ending Parameter])=1 then [Units] END
3. % Increase/decrease: (sum([Selected week])-sum([Selected week -1]))/sum([Selected week -1])
Thank you for the fast response Norbert,
I really like your approach to this - however I'm so sorry I should have mentioned, this will be updated every week. So is there a way around adding to the week ending parameter manually every week?
Find my updated approach as reference and stored in attached workbook version 9.3 located in the original thread.
Based on a excel file with all week ending dates for 2017 I updated the parameter. Based on this approach you are fine for the coming year:)
Thank you Norbert,
This is very helpful.
You are welcome. Glad it worked!. Thanks for the "Badges":))