Hi,

Pls help. Anyone can solve the following problem:

I would like to create a pivot table with the following format:

Defect%
Order Type Total
A 1.11
B 7

Where Defect% = (Defect Qty / Order Qty) * 100
and Order Qty for Work Order 40037 is 718, Work Order 40038 is 1177 and
Work Order 40039 is 100

With the following data source:

Work Order, Order Type, Order Qty, Defect Code, Defect Qty
40037 A 718 X10 2
40037 A 718 X11 1
40037 A 718 X12 1
40037 A 718 X13 1
40037 A 718 X14 2
40037 A 718 X15 3
40037 A 718 X16 2
40038 A 1177 X13 2
40038 A 1177 X14 1
40038 A 1177 X15 2
40038 A 1177 X16 2
40038 A 1177 X17 2
40039 B 100 X10 2
40039 B 100 X11 1
40039 B 100 X12 1
40039 B 100 X13 2
40039 B 100 X14 1



Thanks!


+-------------------------------------------------------------------+
|Filename: ExcelForum_PivotTable.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=5078 |
+-------------------------------------------------------------------+

--
ahhua
------------------------------------------------------------------------
ahhua's Profile: http://www.excelforum.com/member.php...o&userid=36684
View this thread: http://www.excelforum.com/showthread...hreadid=564198