I'm trying to use a specific week's rolling average and apply that average to weeks with incomplete data.
In the example below, I'd like the take the max week (14.4 % in Week 7) and apply that as the to the remaining weeks (10,762 * .144,12,789 * .144, etc.).
In this example, I'm using rolling 4 weeks. So, Week 7's rate calc is SUM(C5:C8)/SUM(B5:B8)
I can create the rolling average easy enough using table calculations but I'm struggling to capture that single week's rate to apply in other viz's