Contoh Latihan Data Pivot Table.xlsx

	A	B	C	D	E	F	I	J	K	L	M	N	O	P	Q
1	DATA PENJUALAN BARANG
2
3	TANGGAL	KODE BARANG	CABANG	JUMLAH TERJUAL	HARGA BARANG	UANG YANG DITERIMA	CABANG	AVERAGE of JUMLAH TERJUAL
4	01/01/11	1	YOGYAKARTA	20	Rp50,000	Rp1,000,000	BANDUNG	45
5	01/02/11	2	BANDUNG	25	Rp25,000	Rp625,000	MEDAN	56
6	01/03/11	3	SURABAYA	10	Rp15,000	Rp150,000	SEMARANG	50
7	01/04/11	4	SEMARANG	67	Rp10,000	Rp670,000	SURABAYA	37
8	01/05/11	5	MEDAN	45	Rp55,000	Rp2,475,000	YOGYAKARTA	42
9	01/06/11	1	YOGYAKARTA	34	Rp50,000	Rp1,700,000	Grand Total	46
10	01/07/11	4	SEMARANG	40	Rp10,000	Rp400,000
11	01/08/11	1	YOGYAKARTA	67	Rp50,000	Rp3,350,000
12	01/09/11	3	SURABAYA	23	Rp15,000	Rp345,000
13	01/10/11	4	SEMARANG	24	Rp10,000	Rp240,000
14	01/11/11	2	BANDUNG	12	Rp25,000	Rp300,000
15	01/12/11	4	SEMARANG	34	Rp10,000	Rp340,000
16	01/13/11	5	MEDAN	56	Rp55,000	Rp3,080,000
17	01/14/11	3	SURABAYA	23	Rp15,000	Rp345,000
18	01/15/11	8	MEDAN	56	Rp55,000	Rp3,080,000
19	01/16/11	3	SURABAYA	34	Rp15,000	Rp510,000
20	01/17/11	2	BANDUNG	78	Rp25,000	Rp1,950,000
21	01/18/11	1	YOGYAKARTA	65	Rp50,000	Rp3,250,000
22	01/19/11	5	MEDAN	45	Rp55,000	Rp2,475,000
23	01/20/11	3	SURABAYA	65	Rp15,000	Rp975,000
24	01/21/11	2	BANDUNG	45	Rp25,000	Rp1,125,000
25	01/22/11	7	MEDAN	67	Rp55,000	Rp3,685,000
26	01/23/11	4	SEMARANG	45	Rp10,000	Rp450,000
27	01/24/11	2	BANDUNG	65	Rp25,000	Rp1,625,000
28	01/25/11	3	SURABAYA	45	Rp15,000	Rp675,000
29	01/26/11	8	MEDAN	67	Rp55,000	Rp3,685,000
30	01/27/11	4	SEMARANG	87	Rp10,000	Rp870,000
31	01/28/11	3	SURABAYA	56	Rp15,000	Rp840,000
32	01/29/11	2	BANDUNG	43	Rp25,000	Rp1,075,000
33	01/30/11	1	YOGYAKARTA	23	Rp50,000	Rp1,150,000
34
35							SUM of JUMLAH TERJUAL	KODE BARANG
36							CABANG	1	2	3	4	5	7	8	Grand Total
37							BANDUNG		268						268
38							MEDAN					146	67	123	336
39							SEMARANG				297				297
40							SURABAYA			256					256
41							YOGYAKARTA	209							209
42							Grand Total	209	268	256	297	146	67	123	1,366
43
44
45							CABANG	SUM of JUMLAH TERJUAL
46							BANDUNG	268
47							MEDAN	336
48							SEMARANG	297
49							SURABAYA	256
50							YOGYAKARTA	209
51							Grand Total	1,366
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100