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.
Bookmarks