I have a daily, weekly, and monthly total for counts. At the moment, I have the weekly total set up with a simple SUM, which gives me my totals for the week. Is there any way to have the month column take whatever is in the weekly column and add to it additively/progressively? i.e. week 1 has a total of 20, which would bring the current month total to 20, then week 2 total is 10, so it moves the month total to 30.
I haven’t found a way to make the results of a sum remain permanent, and then add the next sum to it. I also don’t know if that is even possible.
Example data:
