Creating Items Purchased report using PivotTable Sample 3 pg 101

Sample 3

	A			B			C		D  		E		F		G
1
2
3							MTH
4 	ITEM 
	PURCHASED	Date		1		2		3		4		Grand Total
5 	gum X		Sum of QTY	35		55		50		50		190
6				Sum of 
				RM-DEBIT	124,114 673,087	416,258 167,548	1,381,006
7 	gum z		Sum of OTY	25		65		25		120 	235
8				Sum of 
				RM DEBIT	43,532	777,392	73,079	714,965	1,608,968
9 	Pencil 2A	Sum of QTY	55		35		55		35		180
10				Sum of
				RM DEBIT	518,521	699,468	306,505	48,825	1,573,319
11	Pencil 28	Sum of QTY	65		25		50		40		180
12				Sum of 
				RM DEBIT	461,609	453,550	447,194	166,429	1.528,783
13 	Total Sum				180		180		120				785
	of QTY
14 	Total Sum
	of RM-DEBIT				1,147,775	2,603,498	1,243,036	1,097,767	6,092,075
15

This report shows the quantity and value of the monthly purchases of each item.

Here are the steps to produce it:

1. Follow steps 1 to 13 from Sample 1.

2. Drag the button ITEM PURCHASED (partly hidden) into the box ROW. Drag the button MTH into the COLUMN box. Drag the button QTY into the DATA box. Now, drag the button RM-DEBIT into the DATA box but below the button QTY, and drop it there.

3. Follow steps 15 to 17 from Sample 1.

You should get the above report in a new sheet.

NOTE

If the button label is Count of RM-DEBIT, we will want to change it to Sum of RM-DEBIT. To do this: right-click on the button. A floating menu will appear. Select Field Settings. The PivotTable Field dialog appears. Under the label Summarize by, select Sum and click OK. Now the label Count of RM-DEBIT should become Sum of RM-DEBIT.

101