My boss gave me a project to do and I'm not too sure how to get it lined up. He wants totals and averages within a dashboard that includes sales and number of orders per month per year. I can get July laid out but he wants a running total also for August. I don't want to add endless columns to the sheet because that defeats the dashboard sheet. I tried working with a pivot table and I don't believe it would be right for him. He doesn't want to have to click here and there. Just look at the numbers. Anyone offer some suggestions?
