Pivot Table Calculated Fields ??

Okay, I currently have a pivot table of data. In the two
columns next to it (not a part of the pivot table), I've
typed in forumla percentages as outlined in the below
example:
|----------------PIVOT TABLE-------------|
Trans Color Units Total %A %B
Cars Red 15 15 39%
Blue 10 10 26%
Green 13 13 35%
Cars Total 38 38 100% 15%

Trains...
Boats....
etc......
Grand Total 100%

%A is the percentage of the Trans group and %B is a
percentage of the Grand Total. Now any time I update the
source data and a new color is introduced, all my formulas
are off by one row. I'm trying to figure out an automated
calculation field to include with the pivot table (so
everything will line up on new updates), but with no luck.
Can this be done?

see Debra Dalgleish's site for an overview to GetPivotData:
http://www.contextures.com/xlPivot06.html

Corey wrote:

Okay, I currently have a pivot table of data. In the two
columns next to it (not a part of the pivot table), I've
typed in forumla percentages as outlined in the below
example:
|----------------PIVOT TABLE-------------|
Trans Color Units Total %A %B
Cars Red 15 15 39%
Blue 10 10 26%
Green 13 13 35%
Cars Total 38 38 100% 15%

Trains...
Boats....
etc......
Grand Total 100%

%A is the percentage of the Trans group and %B is a
percentage of the Grand Total. Now any time I update the
source data and a new color is introduced, all my formulas
are off by one row. I'm trying to figure out an automated
calculation field to include with the pivot table (so
everything will line up on new updates), but with no luck.
Can this be done?

--

Dave Peterson