You're welcome, and thanks for letting me know that you found it.
When you post a question, if you mention which version of Excel you're
using, the responses can include version specific instructions.

Tim Whitley wrote:
Nevermind, I found where it is in 2007. Thanks for your help.

"Tim Whitley" wrote:


That sounds like the right answer but I don't see how to do that in my
version of excel. I have 2007.

"Debra Dalgleish" wrote:


Select one of the heading cells for ReportingYear
On the PivotTable toolbar, click PivotTableFormulasCalculated Item
Type a name, e.g. Diff
For the Formula, subtract one year from the other, e.g.:
='2007' -'2006'
Click OK

Tim Whitley wrote:

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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html