By far the easiest way that I have found is to insert a new column into the
source data and concatenate the Part Number to the Description and call it
something like Full Part. Now you can just drop the full part on the pivot
and all is well...
--
HTH...

Jim Thomlinson


"goofy11" wrote:

I understand that Pivot Tables aggregate data based on hierarchy's--however,
is there any way (perhaps using vba) to modify a Pivot Table to display 2 or
more fields on the same line if the fields are on the same hierarchy level?
I often utilize Pivot Tables by showing sales data by item and filter this
data using fields in the page area. I would love to be able to display item
number and description on the same line; however, since it functions as a
hierarchy it automatically displays them on 2 lines. I'm new to vba, but I
know vba allows you to do things that are otherwise impossible. Can vba
allow you to do what I'm asking? Below I've listed an example of how it is
currently displayed, and below it, how I'd like it to display.

Item Description Sales
22222 2 (what it
does)
Widget 2
---------------------------------------------------------------------------------
Item Description Sales
22222 Widget 2 (what I'd
like)


Thanks,
Jeff