I would appreciate your input on this task. I am attaching a sample workbook, where i try to calculate running_sum on prior_4_wk avg calculation. The first tab has two metrics (ordercnt and ordercnt_prior 4 wk avg) by hour for the selected period. The second tab has running_sum on ordercnt, which works correctly. However, the same calculation fails for the prior 4 wk avg metric and shows blank (tab 2). I assume it has to do with the date filter which is impacting the underlying calculation.