Our organization produces and distributes a "Daily Labor Report" that compares sales to labor for each day, and for the week.
Part of the report includes rows for Sales Forecast and Actual Sales numbers, which provides totals for the week.
I'd like to provide a "week to date" total for each row so we can see of we're progressing.
For example if we have enter actual sales amounts for Monday thru Wednesday, I'd like to see/show the sales forecast total for the those days days only. Currently, it only shows the entire week.
What's the best way to do that.
Part of the report includes rows for Sales Forecast and Actual Sales numbers, which provides totals for the week.
I'd like to provide a "week to date" total for each row so we can see of we're progressing.
For example if we have enter actual sales amounts for Monday thru Wednesday, I'd like to see/show the sales forecast total for the those days days only. Currently, it only shows the entire week.
What's the best way to do that.