Can anybody recommend or have an efficient way to calculate Year over Year and Week over Week percent change?
thanks
Awesome...that works! Thanks!
This will depend greatly on what your data looks like.
Could you show some data as a example?
I'm attaching an example file which contains calculations showing YoY and WoW calculations. The YoY is based on date divided by 364 days prior and WoW is based on date divided 7 days prior.
