Pivot Table "Difference From" Question

[Tim Whitley]

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]

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

 

[Tim Whitley]

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

 

[Tim Whitley]

Nevermind, I found where it is in 2007. Thanks for your help.

 

[Debra Dalgleish]

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.