Is there a way to run a comparative sales report? I would like a report to compare year to year sales by customer that will let me know, similar to the layout of the comparative income statement, if sales are favorable or unfavorable and by what dollar and percentage. I'm not finding an efficient way to do this in Excel.
