Hi

In your PT, right click and choose Table Options. De-select Grand Totals by
Row.
Right click again and choose Pivot Table WizardLayoutdrag Sales amount to
the data area a second time.
Double click on the Sum of Sales2 icon and from the dropdown Show Data
aschoose Difference FromBase Field YearBase Item 2006OK.OK.Finish.

On the PT, drag the Data button and drop on Total and you will see the
values side by side.


--
Regards
Roger Govier



wrote in message
ups.com...
I use a pivot table to show sales by customer. i am looking at sales
for year 2006 and 2007. i placed the customer name field in the row
label, and the sales amount field in the values area of the pivot
table. i placed the year field in the column label to look at the 2
years seperately. is there a way to use the pivot table to calculate
the difference between the 2 years for each customer rather than
calculating the grand total for the 2 years for each customer.
thanks.
T