Excel 2002 Pivot Table calculated field percentage.

  • Thread starter Thread starter ~Dave
  • Start date Start date
D

~Dave

I have the following pivot table format:
Please note that the numbers are calculated fields for net debit and credits.

(Column)
Year 1998 % 1999 % 2000 % Total
(Row)
Accounts
xxxx $456 ?? $552 ?? $600 ?? $1608
xxxx
xxxx

I would like to calculate the percentage variance for each account (xxxx) per year based upon the previous year.

Having problems inserting a percentage field using the calculated fields.

Example, the $456 dollar field is a calculated field derived from the net of the debit and credit fields of the account. The debit and credit fields are hidden in this table.
 
Add another copy of the Net field to the data area
Right-click on its column heading
Choose Field Settings
Click the Options button
From the Show data as button, choose % Difference from
For Base Field, choose Year
For Base Item, choose (previous)
Click OK
 
Thank you and I got the data items to appear horizontal,
but the percentages all grouped between the Total and the years. I need
the year total then the percentage, then the next year and that years
percentage. Is there no way to stagger the year with the appropiate %
variance? I copied the net field and renamed it but it does not appear on
the field list. The net field is a calculated field.
 
Right-click on the Year button, and choose Order>Move Left.
The Net field will only appear in the field list once.
 
Back
Top