Creating Item Sold report using Pivot Table Sample4 pg 109 110

Sample 4

In this sample report, we show the total quantities and values of each item.

	A			B	C		D
2
3 	ITEM SOLD	MTH		Data			Total
4 	Model A		1 		Sum of QTY		249,048
5					Sum of RM-CREDIT	(1,323,990)
6				2 	Sum of QTY		203,897
7					Sum of RM-CREDIT	(1,099,449)
8				3 	Sum of QTY		282,726 
9					Sum of RM-CREDIT	(1,521,920)
10				4 	Sum of QTY		49,324
11					Sum of RM-CREDIT	(260,878)
12	Model A Sum of QTY					784,995
13	Model A Sum of RM-CREDIT				(4,206,237)
14	Model B		1 		Sum of QTY		162,610
15					Sum of RM-CREDIT	(865,699)
16				2 	Sum of QTY 		235,906
17					Sum of RM-CREDIT	(1,249,328)
18				3 	Sum of QTY 		252,330
19					Sum of RM-CREDIT	(1,376,298)
20				4 	Sum of QTY		159,215
21					Sum of RM-CREDIT	(849,610)
22	Model B Sum of QTY					810,061
23	Model B Sum of RM-CREDIT				(4,340,934)
24	Model C		1 		Sum of QTY		136,341
25					Sum of RM-CREDIT	(722,783)
26				2 	Sum of QTY		198,838
27					Sum of RM-CREDIT	(1,077,941)
28				3 	Sum of QTY		247,709
29					Sum of RM-CREDIT	(1,364,610)
30				4 	Sum of QTY		344,895
31					Sum of RM-CREDIT	(1,779,477)
32	Model C Sum of QTY					927,783
33 	Model C Sum of RM-CREDIT				(4,944,811)
34 	NR			0 	Sum of QTY		0
35					Sum of RM-CREDIT	(42,626,171)
36				1 	Sum of QTY		180
37					Sum of RM-CREDIT	(8,271,572)
38				2	Sum of QTY		180
39					Sum of RM-CREDIT	(4,234,128)

109

Here are the steps:

1. Follow steps 1 to 13 from Sample 1.

2. Drag the button ITEN SOLD into the ROW box and drop it there. Drag the button NTH 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. Drag the button RN CREDIT 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.

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.

If Count of RN-CREDIT appears instead of Sum of RM-CREDIT, follow the similar steps as shown under Sample 1 to change Count of RM-CREDIT to Sum of RM-CREDIT.