Matthew welcome to the forums! You certainly get extra points for humor. We're going to need a packaged workbook with some dummied up data, so we can see what's in play. The things you're asking for involve Table Calcs so every dimension you put into or take out of the view will need to be accounted for.
It's a quite simple dataset.
I have data through 11/5. In the sheet I've added the Forecast to 12/13.
Looking to get a cumulative running sum somewhere that incorporates both actual and estimated values.
1) Next to Response on 11/5, it should read 1061
2) By 11/20, it should read 5288 (and thereby we should reach our goal by 11/20)
and so on.
Lastly, when tomorrow comes and new data is available, forecast should function correctly, but anchor to 12/15.
BSW-Example.twbx 27.9 KB
Looks simple but isn't. Somehow copying the current tab by hitting CTRL+C and pasting on a new tab by hitting CNTRL+V lets you perform table calcs. See attached.
PS: Right clicking the tab and hitting copy and paste on new sheet doesn't work. CNTRL+C/CNTRL+V will.
BSW-Example.twbx 49.3 KB
Okay, everything's Kool and the Gang, right? But what happens tomorrow?
I would call this a hack, because tomorrow, that clipboard won't update. I'd love to be able to set it and forget it, and while this does give me the cumulative value, it's doing it by pasting values rather than being dynamic.
Perhaps this is not possible?