You should also be able to bring them with you in the Pivot table. Just make sure you included the whole range when you created the Pivot table, and then do as you have already done, but now also drag the other fields one by one BETWEEN the ROW field and the DATA field. You will initially end up with a horrible looking mess with Totals all over the place that are meaningless, but just right click on each of the areas in the ROW fields marked Totals, choose field settings and then where it says Subtotals, choose NONE.
Eg (Excuse the artistry):-
Code:
Sum of price Year
PartNum 2003 2004
-------------------------
a | ww ww
b | xx xx
c | yy yy
d | zz zz
Table as it stands should look like this. Now drag one of your description fields to between the PartNum field and the Data field, ie where the | is, and it will then look like this
Code:
Sum of price Year
PartNum Desc 2003 2004
-------------------------
a | abc | ww ww
a total | | ww ww
b | def | xx xx
b total | | xx xx
c | ghi | yy yy
c total | | yy yy
d | jkl | zz zz
d total | | zz zz
Those totals are meaningless, so just right click on for example where it says 'a total', choose field settings and then where it says Subtotals choose none. Your data should now look like this:-
Code:
Sum of price Year
PartNum Desc 2003 2004
-------------------------
a | abc | ww ww
b | def | xx xx
c | ghi | yy yy
d | jkl | zz zz
Now just repeat for each description field you want to bring over.
Regards
Ken....................
----------------------------------------------------------------------------
![[peace] [peace] [peace]](/data/assets/smilies/peace.gif)
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------