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.
Would appreciate any suggestions. Thanks!
Please don't start mixing threads, can you close this one out, mark one of the answers as correct, and start a new thread for your new issue? Thanks