Thank you so much for helping me out. Your solution works, but I’d like to find a way for the running sum works for the totals also. Ideally, I’d hide all of the data for the week and show it on a dashboard with the Tacos Sold by Day worksheet.
Incorrect Grand Total/Subtotal:
This is what I’d like the report to look like with the correct numbers:
This is what it looks like using the current solution. Is there any way to turn it into the solution I want?
I understand your request, but I don't have easy answer for that additional request, unfortunately.
Your data ahs 2nd data source and I can guess it's complicated from the beginning...
Thanks Shin! I really appreciate all your help!