I am trying to create a table that has an accumulated total of the previous days values. The days are actual ship days and not always consecutive.
In addition to this, I need to build an accumulating goal value for each day to compare accumulated actual shipped qty to accumulated goal qty.
Similar to below:
73 is the daily goal, each day 73 is added to the previous days accumulated goal.
This is what I am trying recreate using the data:
Anyone doing something like this or know how I would go about it?
Thank you!