Creating Item Sold report using Pivot Table Sample2 pg 107 108

Sample 2

In this sample report, it shows the monthly sales of each item.

	A				B		C
2
3 	Sum of QTY
4 	ITEM SOLD		MTH		Total
5 	Model A			1		249,048
6					2		203.897
7					3 		282.726
8					4		49.324
9 	Model A Total			784.995
10 	Model B			1		162.610
11					2		235,906
12					3		252,330
13					4		159,215
14 	Model B Total			810,061
15 	Model C			1		136,341
16					2		198,838
17					3		247,709
18					4		344,895
19 	Model C Total			927,783
20 	NR				0		0
21					1		180
22					2		180
23					3		180
24					4		245
25 	NR Total				785
26	Grand Total				2,523,624
27

107

Follow these steps:

1. Follow steps 1 to 13 from Sample 1.

2. Drag the button ITEM SOLD into the ROW box and drop it there. Drag the button MTH into the ROW box but below the button ITEM SOLD, and drop it there. Drag the button QTY into the DATA box and drop it there.

3. Follow steps 15 to 17 from Sample 1.

You should get the above report in a new sheet.

If the item NR appears and you want to remove it, follow the steps shown for Sample 1.

If Count of QTY appears instead of Sum of QTY, again follow the steps shown in Sample 1 to change Count of QTY to Sum of QTY.