Pivot Table "Difference From" Question

  • Thread starter Thread starter Tim Whitley
  • Start date Start date
T

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.
 
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
 
That sounds like the right answer but I don't see how to do that in my
version of excel. I have 2007.
 
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.
 
Back
Top