Here's another twist though. They want to include in this same chart, a weekly forecast with a running total as well. So each week, they forecast 5 installs will be completed.
Week 1 forecast = 5, Running Total = 5
Week 2 forecast = 5, Running Total =10... etc.
This forecast number is not something that is specific to each store, so not sure how to do that.
------------------------------
Kim
------------------------------
Original Message:
Sent: 05-10-2022 08:37
From: Kim Ravizza
Subject: Burnup Chart - Running Totals
Mark,
You ROCK as always! Waterfall chart is exactly what I needed!
Thank you,
Kim
------------------------------
Kim
Original Message:
Sent: 05-10-2022 08:32
From: Mark Shnier (YQC)
Subject: Burnup Chart - Running Totals
The easiest way to do this is either with a summary report where you select running totals for one of the summaries or else for a chart, you can use a waterfall chart type.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 05-10-2022 08:29
From: Kim Ravizza
Subject: Burnup Chart - Running Totals
Good morning,
I'm trying to create a line chart that shows a running total of the number of installs completed each week. I'm able to show the number completed each week, but I also need to show the running total.
e.g.
Week 1 completed 5, running total=5
Week2 completed 5, running total=10
Is this something I can do with a report formula?
TIA
Kim
------------------------------
Kim
------------------------------