how to add a special subtotal in the pivot table?

M

MiaYang

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QUESTION: How can I conditionally compute data in a pivot tables? 1
How to choose maximum value 7
Setting the number of Tabs in a Tab Control 0
Applying Percentages to a Pivot Table 0
Dealing with a Pivot Table (when I don't want to) 0
Sorting in Excel 2000 Pivot Tables 1
What Code and where do I put it to Nest Loop 1
Subtract colums in pivot table 0

Top