1 Reply Latest reply on Mar 26, 2020 10:58 AM by Hari Ankem

    How to show rolling 13 week total?

    Samantha Howell



      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:



      Any advise on how to go about this? Thanks!