How about changing sales year to columns and then write a formula off to the
side of the pivot table to subtract one year from another (e.g. if a given
product's annual totals are in B12, for 2005, and C12, for 2006, use "=
C12-B12").
Will

"Wanna Learn" wrote:

Hello I have a pivot table and I'm trying to calculate the dollar amount
difference between 2005 and 2006. ON the ROW I have the product name and
the invoice sales year on the DATA I have total units sold and tota sales
I've tried a calculated field but I do not have the right fields to create
the formula thanks