Year to Year comparison report

[Peter Gar]

I have a boatload of daily transactions that i want to create a report with. Comparing revenue from one year to the next.

How do I create a report that shows 2005 sales and 2006 side by side?

It would look something like this:

DATE - 2005 - 2006

--------------------------------

Jan 1 - $1234 - $3456

Jan 2 - $3456 - $2341

Jan 3 - $567 - $97

Etc.

---------------------------------

Jan Totals - $5287 - $5894

I've enclosed some sample data.

Thanks in advance for your help!

Peter

2005_2006_transactions.txt.zip