I have a worksheet that contains sales records by person. Each record
includes the month of the sale; there can be multiple records for each
salesperson for each month. Each record also has a field that indicates the
data identifies the record as Sales or Quota.

I have set up a pivot table that shows:
Salesperson, Jan2007Sales, Jan2007Quota, Feb2007Sales, Feb2007Quota,
Mar2007Sales, Mar2007Quota, ... , Total2007Sales, Total2007Quota

Is there a way to add a column after each month that shows the difference
for that month between the Sales amount and the Quota amount:
Salesperson, Jan2007Sales, Jan2007Quota, Jan2007Diff, Feb2007Sales,
Feb2007Quota, Feb2007Diff, Mar2007Sales, Mar2007Quota, Mar2007Diff, ...
, Total2007Sales, Total2007Quota, Total2007Diff

Any help is appreciated...
--
Ed G