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