Creating Items Purchased report using PivotTable Sample 2 pg 100

Sample 2

	A				B		C		D		E		F
1
2
3 	Sum of QTY		MTH
4 	ITEM PURCHASED	1		2		3		4 		Grand Total
5 	gum X			35		55		50		50		190
6	gum Z			25		65		25		120		235
7 	Pencil 2A		55		35		55		35		180
8 	Pencil 2B		65		25		50		40		180	
9 	Grand Total		180		180		180		245		785
10

In this sample, the report shows the monthly quantity of each item purchased. Drag the button ITEM PURCHASED (partly hidden) into the ROW box. Drag the button QTY into the DATA box. Drag the button MTH into the COLUMN box and drop it there.

3. Follow steps 15 to 17 from Sample 1.

You should get the above report in a new sheet.



100