I need to show a rolling 13 week total of pipeline created for the last few years. Ideally, this would be dynamic so it could update on it's own every week.
I need each bar on the X-Axis to show 13 weeks worth of data. So, Bar 1 = March 21 - Dec 22, 2nd bar = March 14 - Dec 14, and so on. I've got the 1st one down but I am not sure how to create the others. This is the formula I used: