my excel look like this:

partnumber instock_qty usedpartnumber
-----------------------------------------
p1 10 fg1
p1 10 fg2
p2 5 fg3
p2 5 fg4
p2 5 fg5
-----------------------------------------

the pivot table looks like this:

partnumber instock_qty usedpartnumber
---------------------------------------------
p1 10 f1
f2
p2 5 f3
f4
f5
---------------------------------------------

if i sum the instock_qty, it will look like this:

partnumber instock_qty usedpartnumber total
--------------------------------------------------
p1 10 f1
10
f2
10
-------------------------------------------------
p1 total
20
-------------------------------------------------
p2 5 f3
5
f4
5
f5
5
------------------------------------------------
p2 total
15
------------------------------------------------

But what i want is:

partnumber instock_qty usedpartnumber
---------------------------------------------
p1 10 f1
f2
---------------------------------------------
p1 total 10
---------------------------------------------
p2 5 f3
f4
f5
---------------------------------------------
p2 total 5
---------------------------------------------

how can i do that? really appreciate your help!


--
MiaYang
------------------------------------------------------------------------
MiaYang's Profile: http://www.excelforum.com/member.php...o&userid=34046
View this thread: http://www.excelforum.com/showthread...hreadid=538091