Pivot Tables - Utterly Confused

[ultratch47]

I know what i want to do, and i am pretty sure that a pivot table is the best approach, however i cant EVER seem to get the pivtot table to come out like i want it. I have found and read tutorials and help files on them, but they never go to in depth.

if anyone has a suggestion, here is my file:
thank in advance

******** LANGUAGE="JavaScript" ************************************************************************>

Microsoft Excel - Book1 ___Running: xl97 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
I2I5 =
	A	B	C	D	E	F	G	H	I
1	Item	Description	Qty	$	*	Item	Description	Qty	$
2	0300	COLLAR	1	*$***19.00*	*	0300	COLLAR	10	*$*190.00*
3	04A5	SHIRT*	3	*$***55.00*	*	04A5	SHIRT*	3	*$***55.00*
4	04BE	SKIRT	5	*$***59.00*	*	04BE	SKIRT	5	*$***59.00*
5	04B7	TEE	1	*$***39.00*	--------->>	04B7	TEE	3	*$*117.00*
6	04CL	CAMISOLE	1	*$***35.00*	*	04CL	CAMISOLE	1	*$***35.00*
7	0300	COLLAR	9	*$***19.00*	*	*	*	*	*
8	04B7	TEE	2	*$***39.00*	*	*	*	*	*
Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.