I am looking to create a "Running Total" or Aggregate Goal vs Actual dashboard for our operators to measure performance.
1. Chart that displays the goal Monday-Friday, but actual output displays Sunday through Saturday (Helping to predict overtime needs)
2. A dynamic goal that can be changed every quarter. The look that I am going for is below:
I have tried to create a parameter, but the aggregate total sums to a value in the millions - the target I want is 3200. I can get the "actual" values to upload, but I cannot figure out how to limit the goal to 5 days only.
Could you attach sample data as packaged workbook?