I have a table that contains the following sales data:

AccountName ReportingYear Revenue

There are 2 years in the data and account name is repeated in the case of
multiple sales to one customer. I want to display the following in a Pivot
Table:

ReportingYear1 ReportingYear2
Difference
AccountName TotalSales for Y1 TotalSalesforY2
DifferenceofY1fromY2

I can't seem to get all of this in one pivot table. In summary, I need to
show the customer's total for each year side by side and then show the
difference at the right.

Thanks for any assistance.