I am trying to count the current consecutive weeks an item is below its average for a given period of time starting with the past week. Not sure how to do this. Item 123 should have an output of 3 since it has been below the average the past 3 weeks. Item 1234 should have an output of 0 since it was above the average last week.
<tbody>
</tbody>
Item | 10/20 | 10/27 | 11/3 | 11/10 | Avg | Consecutive WK Below Avg |
123 | 15 | 8 | 7 | 6 | 9 | ??? |
1234 | 15 | 14 | 10 | 15 | 13 | ??? |
<tbody>
</tbody>