The answer depends on where the data is stored. Do you still have all your invoices and credit notes stored in OE all the way back to 2000? How about a Sales data program such as Sales Analysis or Invoice Sales History?

This most efficient (and easiest) way is to create formulas to get the 2000, 2001 and 2002 amounts. The syntax would be something like:

If Year(Invoice Date)=2000 then Extended Invoice Price else 0

Do the same for years 2001 and 2002. Then subtotal these formulas by Item Number, add the item code, description, and other info into the Group Footer section, and hide the details.

You can make this report use 'floating' dates so that you don't have to update it next year:

If Year(Today)-Year(Invoice Date) = 2 then Extended Invoice Price else 0
would be the same as year 2000 if printed this year.

Regards,