Excel 2007 and I want to see the change in this year versus last year customer purchases per customer but can't figure out how to do so.
I have the information from the accounting program in a table but I don't know how to set up the calculated field so that it shows the change.
The rows have the customer name and the columns have the date field from the table in a group mode. I want to compare the 2011 sales to the current sales date in 2012 too.
Thanks for any help.
Lee