June 6, 200817 yr 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
Create an account or sign in to comment