You could use a custom calculation, instead of a calculated field --
Add another copy of the total sales field to the data area.
Right-click on a cell in the new column, and choose Field Settings
Click Options
From Show data as, choose Difference From
For Base Field, choose Year
For Base Item, choose (previous)
Click OK
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
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html